[AccessD] Make Folder Problem

That was the problem. I already had the higher level directories on my
machine so did not test the whole path. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Friday, April 28, 2006 10:54 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com