Macro directed to wrong drive

1 reply [Last post]
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 03/15/2010
Posts: 1

First, thank you in advance for any help you can offer, because I am truly at wit's end.

We use a macro that is stored in the "personal" file in the XLSTART folder of the local drive.  A new employee wanted the macro, so I copied it to his folder on the network drive and installed it on his local drive and it works fine, however, my macros now look to his folder on the network drive whenever I try to run them.  I have looked at the modules in VB and they are all pointed to the correct folder on my local drive, so why does the macro try to map out to the network drive?  Is there a set-up in Excel that I have corrupted and need to change?

 

Thanks again.

 

jw

 

User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 06/02/2008
Posts: 15
Can you paste your code here?

Are you sure you don't have a shortcut to your new employee's folder instead
of an actual Personal.xls in your \XLSTART\ folder?