Why can't I set a value

[j_Southern]

I found the following piece of code, I think in this forum, and have used it to help find and open files from within Excel.

Please Login or Register  to view this content.

This time, however, I have a problem. When I was first setting up the code I uploaded a standard file from my local disc. The variable FilepathName was given the value of "C:\Users\John\Documents\".
When this was successful the variable FilePathName was set to "U:\Everybody\LabelOrders\Vista\". as needed when the application is used inearnest. The routine still worked but persisted with opening up at the first FilePath.
Watching the code execute showed that at the line marked ****** that fdl.InitialFileName persisted with old value of FilePathName and did not seem to follow the instruction in the code line. This persisted even after I had closed and reopened Excel.
The application is itself filed in C:\Users\John\Documents.
How can I ensure that fdl. InitialFileName is filled with the file path I want?
Johnm

[sktneer]

Are you sure that the path U:\Everybody\LabelOrders\Vista\ exists? Did you type it manually or copied from the explorer window's address bar? Try to navigate to this path in windows explorer and copy the path from the explorer itself, maybe this is misspelled.

[AlphaFrog]

I think you may have to first change the drive before .InitialFileName.

Please Login or Register  to view this content.

Or just this...

Please Login or Register  to view this content.