Macros for Excel 2000

[JHL]

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

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).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

 

[JLatham]

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

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

JHL

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).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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