[AccessD] Make Folder Problem

I don't think you can create a path like "C:\Files\Excel\Scaleup10" in one
step. You need to check if "C:\Files" exists first, then "C:\Files\Excel"
and then finally "C:\Files\Excel\Scaleup10", creating folders along the way.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Friday, April 28, 2006 10:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Make Folder Problem


I use the following code on my machine to create a folder and it works fine.
Just tried it on another users machine and got a message could not create
folder. I was able to do it manually. Any thoughts?

 

ChDrive "C:"

Set fso = CreateObject("Scripting.FileSystemObject")

ResultsPath = "C:\Files\Excel\Scaleup10"

 

If Not fso.folderexists(ResultsPath) Then

    MkDir "C:\Files\Excel\Scaleup10"

End If

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com