[AccessD] Make Folder Problem

If Scripting were not installed, then the CreateObject should fail. Did you also try:

fso.CreateFolder ResultsPath

?  Also,

Regards,

Steve Goodhall


-------------- Original message -------------- 
From: "Jim DeMarco" <Jdemarco at hudsonhealthplan.org> 

> Or maybe it's possible that the Scripting component is not installed on 
> that machine. I seem to recall a few years back sys admins were not 
> installing for fear of attacks. 
> 
> 
> Jim DeMarco 
> 
> -----Original Message----- 
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David A. 
> Gibson 
> Sent: Friday, April 28, 2006 11:01 AM 
> To: Access Developers discussion and problem solving 
> Subject: Re: [AccessD] Make Folder Problem 
> 
> Could it be that the user permissions are different? 
> 
> David G. 
> 
> 
> At 09:47 AM 4/28/2006, you wrote: 
> >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