Macros for Excel 2000

[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

 

[Nick Hodge]

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)

 

[Gord Dibben]

In the XLSTART folder.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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.

 

[David McRitchie]

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

 

[JHL]

Thanks to each one that responded. Apparently, the XLSTART is hidden or no
one used any macros.

JHL

 

[Guest]

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