chdir not working

[venkman]

I have a macro with the following code:

ChDir ThisWorkbook.Path
MsgBox ThisWorkbook.Path
MsgBox CurDir

The first message box displays "e:\results" a folder on a mapped network drive. The second message box displays the mydocuments folder. Why isn't the second the same as the first?

-Venkman

 

[venkman]

Think I've answered my own question:

must add this line to beginning:
ChDrive Mid(thisWorkbook.Path, 1, 1)

-Venkman

 

[RobBroekhuis]

Actually,

ChDrive thisworkbook.path

will do as well
(everything after the first letter gets ignored).

Rob