Macros for Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm now using Excel 2000, but was using Excel 97. I had macros stored in the
Personal.xls and saved in the XLSTART folder. Where do I put this file for
Excel 2000 so I can still use these macro?

Thanks for any help
 
JHL

Same place XLStart. To find it search for hidden folders too (Or show them)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
And you can use this to find where that XLStart folder should be:

Open excel
hit alt-f8 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath

Make a note of it and store your personal.xls in that folder.
 
The XLSTART folder is in the same folder as you invoke Excel from.
The easiest way is to record a macro and then find that copy of your
personal.xls and with Excel down you can copy your old personal.xls
to new location (delete the one you generated).
 
Thanks to each one that responded. Apparently, the XLSTART is hidden or no
one used any macros.

JHL
 
Did you find it or not? Normally the XLSTART folder is in (assuming an
install on C: drive)
c:\Program Files\Microsoft Office\Office11
 
Back
Top