Transporting Excel 97 Macros

[Guest]

If I want to have the same Word 97 macros (and custom menus and toolbars) on
my home machine as on my office machine, I bring home the Normal.dot file.

Is there an equivalent way of doing this in Excel 97?

 

[Bernard Liengme]

Open the files that contain the macros; Open Visual Basic (ALT+F11); click
on each Module in the VBAProject window; Use File| Export to send the macro
to thumb drive (or to hard drive and later to CD)
At home use File | Import to load the BAS files

 

[Peter T]

Your macros may be stored in Personal.xls. If you don't have this already in
your home machine create a new one by recording a dummy macro to your
Personal (can delete it later).

Load a renamed copy of your work personal.xls, in the VBE, F11, drag all
modules from the renamed Personal to your new Personal.

Similarly search your work system for your toolbar *.xlb folder, which in
Excel97 will be named username8.xlb, take a renamed copy home. From memory
(might be wrong about exact way to do this) open the renamed xlb or drag it
into Excel from file. It should merge the settings.

Close & reopen Excel, save your Personal when prompted.

Regards,
Peter T

 

[Guest]

Thank you.