Which is the good PERSONAL folder in XP Pro
 

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.

Which is the good PERSONAL folder in XP Pro
 

Put the location of your personal.xls here...
ToolsOptionsGeneralAlternate startup file location

Re-start Excel.

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"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.

Which is the good PERSONAL folder in XP Pro
 

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

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