Which is the good PERSONAL folder in XP Pro
Both work !
Thanks
"Dave Peterson" wrote:
I'd open excel on the WinXP computer.
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.StartupPath
That's where I'd put that personal.xls file.
And inside the VBE, you can select your project and do Edit|Replace
Make sure you choose to Search in the Current Project.
Leon wrote:
I need to transfer/copy macros written on a Win 98SE computer to an XP Pro
computer.
I tried copying the XLSTart folder from Win 98 to the XLStart folder on the
XP (Program Files/Microsoft Office/Office).
I found out that the macros were not there (on the XP).
Then I tried to copy that XLStart Folder (Win 98) to Windows Application
Data/Microsoft etc...
And it looks like it's working....
Is this the folder I should copy to in the future?
Also the path to "My Documents/Excel" folder is not the same on Win98 and XP.
Is there a quick way to do a "find and replace" the wrong path by the good
one for all the macros in one shot?
I tried but the search and replace only worked for the project but not all
the other macros.
Thanks in advance for any help.
--
Dave Peterson
|