macro pointing to wrong folder

A

ankur

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?
 
G

Gary Brown

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?
 
W

witek

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?

What is a value of

ThisWorkbook.Path
ActiveWorkbook.Path

?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top