VBA ChDir not working on a Network Share

[Vordak]

Hello...

I am trying to change my current directory to a directory on a server.

CurDir says its "C:\....\My Documents\"

I tried to:
ChDir = ("\\cle-filesrv-01\.....\")

but it doesn't change my current path.

Any ideas?

 

[Vordak]

Well, seems like I found a work around..

Had to map the drive, I used Z:\

ChDrive("Z:\")
ChDir(ActiveWorkbook.Path)

Worked, but didn't want to have to do the mapping, because if someone deletes the mapping, the program stops working..

So if anyone else has a thought, let me know.

Thanks

 

[SkipVought]

Hi,

What are you using current directory for? Its a DOS throwback.

I never use, and I reference a network using server designations rather than drives.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}