Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pointing to wrong folder
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pointing to wrong folder
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? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "ankur" wrote: 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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pointing to wrong folder
On 3/16/2010 9:36 AM, ankur wrote:
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel saves to wrong folder | Excel Discussion (Misc queries) | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Printing to PDF Goes to Wrong Drive/Folder | Excel Programming | |||
Pointing custom toolbar entries to correct macro path on copied workbooks | Excel Programming | |||
Where is hyperlink pointing...File or Folder | Excel Programming |