Keeping macros

  • Thread starter Thread starter Doug Wells
  • Start date Start date
D

Doug Wells

I've got lots of Macros on my Excel from Office 97. Now, I'm upgrading
my computer and office suite to Office 2003. I have tons of macros that
I use all the time. How can I export them to my new Excel?

Thanks for the help.
 
Don't know where your macro's are but, in my case, I record my macro's
in a special workbook that I keep in the startup folder.
When I went to Of2k I just copied the workbook to the startup folder on
the new machine.
Maybe something's different in Off2003(?).
 
Doug

Where are they stored currently? Workbooks? Personal.xls? Add-ins?

The upgrade should not disturb any of these unless by "upgrading" the computer
you are buying a new one or re-formatting.

To be safe, round up all the files with macros and save them to a floppy or
CD.

OR Export the modules to *.bas files which can be saved to floppy or CD.

Lotsa options once you know where the macros currently reside.

Gord Dibben Excel MVP
 
Doug Wells said:
I've got lots of Macros on my Excel from Office 97. Now, I'm upgrading
my computer and office suite to Office 2003. I have tons of macros that
I use all the time. How can I export them to my new Excel?

Thanks for the help.
Click to expand...

Be aware the your custom toolbars (which normally refer to macros that
you've recorded and are in personal.xls) are stored in Excel.xlb (or
similar). You may copy this to your system, or attach your custom
toolbars to a workbook and open the workbook on your new system. Same
result, your custom toolbars will appear.

HOWEVER, unless you have exacyly the same path to personal.xls, the
button links will not work. You have to re-direct each and every
button OnAction.

I wrote a spreadsheet to do it, as I maintain a work and home pc with
the same custome toolbars and personal.xls ... you guessed it, I have
different usernames on each pc!

Regards,

Mark
 
We have more than 200 worksheets in the network. Each worksheet has macro buttons that links to the Personal.xls file in XlStart folder(C:\Program Files\Microsoft Office\Office\XLStart\Personal.xls) when we were using Excel. Lately, one of us has upgraded to Office XP. The locations of the macro buttons have changed when he opened the worksheets in XP. They are all pointing to C:\Settings And Applications\.........\Personal.xls. It is a painful to change the link on every macro buttons. I am thinking about creating a macro. Is it the only and best way to do?
 
Back
Top