Save Macro to Floppy Disk

  • Thread starter Thread starter W anda G.
  • Start date Start date
W

W anda G.

I've created many macros but always saved them in the
Normal template document. I need to save a macro to a
floppy disk and have experimented with Organizer and
Macro Project but could not make it work. Would someone
share the steps necessary to store a macro on a floppy
and also steps to run the macro?
 
You can't move a macro by itself. You can move the module that contains
it via the Organizer to another document or template, or (probably the
simplest ) you can copy the template that contains the macro into the
floppy. It's also good to keep backups of your customized templates in
any case.

Finally, you could open the VB editor (Alt+F11), locate the macro
procedure in the Code window, copy it, and paste it into a text file.

Larry
 
Larry said:
You can't move a macro by itself. You can move the module that
contains it via the Organizer to another document or template, or
(probably the simplest ) you can copy the template that contains the
macro into the floppy. It's also good to keep backups of your
customized templates in any case.

Finally, you could open the VB editor (Alt+F11), locate the macro
procedure in the Code window, copy it, and paste it into a text file.

Larry

One more alternative: If you want all of the code in a module, right-click
the module in the Project Explorer window of the VB editor and select Export
File. This will save a .bas file (which is really just a text file), which
you can put on a floppy. On the other end, you can use the Import File
command to bring the .bas file into a template.
 
Back
Top