Moving VBA modules to a new hard disk / and a new computer

[Gordon Filby]

Hi,

owing to the increasing trouble I'm having with my current computer,
regretfully I'm having to move a lot of stuff to a new hardisk on my current
computer and somewhat later to a new computer.

Problem is I have a lot of VBA macros spread across Word, Outlook and
Access. Most of them run from customised toolbars with my own icons.

Is anyone aware of a painless way of doing this? Where are these toolbars
stored?

Using Windows 2000 Pro on a company network with Office XP.Pro

Thanks in advance.

Regards,

Gordon Filby

 

[Andrew Cushen]

Gordon-

Most of your Outlook macros are probably stored in
VBAProject.OTM.

Most of your Word macros are probably stored in normal.dot.

As far as Excel, the macros may be stored in regular Excel
files, or in add-in files- files with an .XLA extension.

The bad Word macros may be, like Excel macros,
spread across Word document files. Outlook can be
extensively customized using custom forms, which can have
VBScript behind them. And, all 3 apps can also have
compiled COM Add-ins.

So, there is no easy way AFAIK. I would start by opening
the VBA Editors in Word and Outlook- you do this by
pressing Alt+F11- and copying ALL the text you find in
each main window, then pasting each into its own text
file. You can then reverse the process on your new PC,
pasting the code from the files into the VBA windows.
You could also look into exporting the VBA code as modules
from within the VBA Editor.


If anyone can add to this, please do.

-Andrew
=======================================