Macros for Excel 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JHL - 01 Jun 2006 22:10 GMT

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

Reply to this Message

Nick Hodge - 01 Jun 2006 22:26 GMT

JHL

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> I'm now using Excel 2000, but was using Excel 97. I had macros stored in
> the
[quoted text clipped - 3 lines]
>
> Thanks for any help

Reply to this Message

Gord Dibben - 01 Jun 2006 23:11 GMT

In the XLSTART folder.

Gord Dibben MS Excel MVP

>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

Reply to this Message

Dave Peterson - 02 Jun 2006 02:05 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

David McRitchie - 02 Jun 2006 19:00 GMT

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

Reply to this Message

JHL - 03 Jun 2006 01:15 GMT

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
[quoted text clipped - 13 lines]
>>
>> Thanks for any help

Reply to this Message

JLatham - 10 Jun 2006 02:22 GMT

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.
[quoted text clipped - 18 lines]
> >>
> >> Thanks for any help

Reply to this Message