Macro opens to specific folder BUT doesnt work for network drive

**lsteinbach** · 01-03-2013, 12:45 PM

Hello,

The macro I use opens the search window to find a file in a specfic folder. This specific folder is located on a network drive. When first using the macro, it only opens to "My Documents" and not the specific folder. Only when I navigate to the network drive does the macro finally work from henceforth. Is there a way to correct this?
Here is the macro I use where K is the network drive:

Please Login or Register  to view this content.

Thank you for any help.

- Luke

**6StringJazzer** · 01-03-2013, 08:08 PM

ChDir changes the current directory on the specified drive but doesn't change the active drive. To change the drive too add the following line before or after your ChDir call:

Please Login or Register  to view this content.

**lsteinbach** · 01-04-2013, 12:19 PM

Thank you sir!

**6StringJazzer** · 01-04-2013, 06:27 PM

I am going to add a little more explanation to this for those joining late. This is a carryover from DOS, and still works like this in Windows Command Line, and the file system API used by VBA. This explanation is for those who never used DOS or Windows Command Line.

There is no one single current directory. Each drive has its own current directory. If you change which drive is active, then you get that drive's current directory. In the example above, the active drive is C. The code changes the current directory on the K drive, but C continues to be the active drive. Once you change the active drive to K you get whatever you just set the current directory to.

This has its advantages; once you set the desired current directories it is easier to switch back and forth between drives by just giving the drive letter. But it's not completely intuitive.