MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Directory Path Problem with SHORTCUT

Posted by Mark G. on December 11, 2001 9:26 AM

I created a program for departments to access on the network. When the users are not using my program, their deafault path is always C:\MY DOCUMENTS.
When I manually launch the program from the network, it runs perfectly. There are menu selections to look at PENDING or BILLED(directories up on the network). Selecting these menu options runs the excel VBA ChDir to the appropriate folder on the network.
My problem now is I created a shortcut on their desktop that calls the file from the network. But now when they select the menu option to look at files on network folders, the C:\MY DOCUMENTS folder appears instead. Why is the shortcut ignoring the VBA? How can I override this so it calls up the right directories? Thanks.

Posted by Ben H on December 11, 2001 11:36 AM

Are you using an absolute or relative reference in your ChDir statement? If you specify the entire path, I can't see why you'd have a problem. Could you provide the exact code you're using for this?