Which is the good PERSONAL folder in XP Pro

[Leon]

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.

 

[Gary L Brown]

Put the location of your personal.xls here...
Tools>Options>General>Alternate startup file location

Re-start Excel.

HTH,

 

[Dave Peterson]

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]

Both work !

Thanks

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.