ChDir not working properly... Any ideas?

[j844929]

Hi, I'm using the ChDir command in VBA to select the correct directory in which to save a file, but it isn't selecting the directory. The code I've used is below...

ChDir "C:/com-user/COM-DATA/"

Does anyone have any ideas or alternatives that might work a little better?

 

[BrianB]

Use ChDrive "C" first

 

[j844929]

Thought it might be an easy one... thanks!