Personal.xls copying?

J

JohnL

Help. I am getting a new computer at work and want to save my macros. How
can I find the personal.xls file, copy it to my company's intranet drive and
then after my new computer is set up, copy the file onto the C drive of the
new computer.?

Thanks in advance

John
 
D

Dave Peterson

I'd use windows start button|Search
to look for personal.xls
Remember to look in hidden folders, too.

It should be in your XLStart folder.

If you have trouble finding it...

Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window

type this and hit enter:
?application.startuppath

for me (xl2003, winXP Home), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

You may want to do the same thing on the new pc. Just to make sure you put the
file in the correct location.
 
Top