Using ChDir function on network resource

[GlennUK]

Hi all,

I'm trying to use ChDir on a network resource like this:

ChDir "\\svr10\XYZ\ABCD"

but this doesn't change what the active directory is. I know that you issue a ChDrive command to point to the correct mapped drive when the resource you want is a mapped drive, but I need to know what to do to make this network resource the active working directory.

Do I need to issue a mapping command to get this resource allocated to a drive letter, and then issue the ChDrive command?

Thanks, Glenn.

 

[SQLBI]

Hi,

I assume you mean the default file path on the General tab of Tools > Options.

Application.DefaultFilePath "\\YourServer\YourPath"

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[GlennUK]

Hi Leigh Moore,

you assume wrong I'm afraid. I don't want to change the default file path, I want to change the current drive to point at the network resource.

( By the way, you missed the "=" out of your statement )

Cheers, Glenn.

 

[GlennUK]

Got a workaround.

I was going to use ChDir followed by Dir to get all the files on a network resource.

Instead I used:
myname = Dir("\\svr10\XYZ\ABCD\*.xls&quot

followed by calls to Dir without args, and it does what I want.

Thanks anyway.
Cheers, Glenn.