Excel 97 migrating macros and toolbars to new 'used' computer

[Zilbandy]

Setting up a second used computer and have installed Office 97. I
copied my old .xls files to it. When opening those files on new
computer, Some custom toolbars are missing and all my macros are
missing, too. Can anyone tell me how to get them from old computer to
the new one? Google didn't help me.

 

[Michael Bednarek]

Setting up a second used computer and have installed Office 97. I
copied my old .xls files to it. When opening those files on new
computer, Some custom toolbars are missing and all my macros are
missing, too. Can anyone tell me how to get them from old computer to
the new one? Google didn't help me.

Search for PERSONAL.XLS and EXCEL.XLB on your old computer. They are
likely to be in C:\Documents and Settings\%USERNAME%\Application
Data\Microsoft\Excel\ and its subdirectory XLStart\. In more recent
versions of Windows, this location is now %APPDATA%\Microsoft\Excel\.

Good luck.