View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Change from 2K to XP - global macro location chnge?

Hi Ed,

I'm not totally clear what you're asking. If you mean that you have set
a reference to the personal.xls VBProject in a bunch of workbooks and now
that reference says MISSING, then you'll have to go through each workbook
that has this problem, uncheck the reference, close the Tools/References
dialog, then go back in a re-select the reference. If this isn't what you
mean, can you be more specific?

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Ed" wrote in message
...
"Ed" wrote in message
...
IT just changed me from Office 2K and Windows 2K to Office and Windows

XP.
whoopie 8\


Just discovered all my macros are addressed for Win/XL2K to look for
Personal.XLS in a folder that doesn't exist any more! Personal.XLS is now
stored in a different location. How do I do a global change on 39 modules
to make them point to the new location?

Ed