Macros for Excel 2000 JHL 01.06.2006 21:10:02 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

Re: Macros for Excel 2000 "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 01.06.2006 21:26:02 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 nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS "JHL" <JHL[ at ]discussions.microsoft.com> wrote in message news:9A28A9B5-FBEC-48A9-9DAC-1892A7990CD8[ at ]microsoft.com... [Quoted Text] > 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

Re: Macros for Excel 2000 Gord Dibben <gorddibbATshawDOTca> 01.06.2006 22:11:59 In the XLSTART folder. Gord Dibben MS Excel MVP On Thu, 1 Jun 2006 14:10:02 -0700, JHL <JHL[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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

Re: Macros for Excel 2000 Dave Peterson <petersod[ at ]verizonXSPAM.net> 02.06.2006 01:05:02 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. JHL wrote: [Quoted Text] > > 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 -- Dave Peterson

Re: Macros for Excel 2000 "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 02.06.2006 18:00:39 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 "JHL" <JHL[ at ]discussions.microsoft.com> wrote in message news:9A28A9B5-FBEC-48A9-9DAC-1892A7990CD8[ at ]microsoft.com... [Quoted Text] > 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

Re: Macros for Excel 2000 "JHL" <mg19512000[ at ]yahoo.com> 03.06.2006 00:15:50 Thanks to each one that responded. Apparently, the XLSTART is hidden or no one used any macros. JHL "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> wrote in message news:OzUrN6mhGHA.3496[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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 > > "JHL" <JHL[ at ]discussions.microsoft.com> wrote in message > news:9A28A9B5-FBEC-48A9-9DAC-1892A7990CD8[ at ]microsoft.com... >> 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 > >

Re: Macros for Excel 2000 JLatham 10.06.2006 01:22:01 Did you find it or not? Normally the XLSTART folder is in (assuming an install on C: drive) c:\Program Files\Microsoft Office\Office11 "JHL" wrote: [Quoted Text] > Thanks to each one that responded. Apparently, the XLSTART is hidden or no > one used any macros. > > JHL > > "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> wrote in message > news:OzUrN6mhGHA.3496[ at ]TK2MSFTNGP04.phx.gbl... > > 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 > > > > "JHL" <JHL[ at ]discussions.microsoft.com> wrote in message > > news:9A28A9B5-FBEC-48A9-9DAC-1892A7990CD8[ at ]microsoft.com... > >> 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 > > > > > > >