Q about exporting macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Saffer - 16 Mar 2006 17:38 GMT

Greetings,

I have forgotten the best way to export a macro from one computer, then
import it to another.

Depending on where I am, either under tools > macro > macros > edit,
or under tools > visual basic editor, I see two different files types, .cls
and .bas.

I always thought macros were .bas files, so that's why I'm writing.

Let's say I have a macro in Personal.xls. What's the best way to copy it,
and can I get a brief explanation between .cls and .bas?

Much obliged,

Signature

Mike
Jacksonville, Florida

Reply to this Message

Bernard Liengme - 16 Mar 2006 18:42 GMT

Open VBA editor
Click on each module in turn on the Project Window
Use File | Export to send a BAS file to some folder
...
Transfer folder to next PC
...
Then
Open VBA editor
Select appropriate workbook in Project Window
Use File | Import

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Greetings,
>
[quoted text clipped - 12 lines]
>
> Much obliged,

Reply to this Message

Mike Saffer - 17 Mar 2006 17:25 GMT

Thank you. Works fine.

Best,
Mike
Jacksonville, Florida

> Open VBA editor
> Click on each module in turn on the Project Window
[quoted text clipped - 23 lines]
> >
> > Much obliged,

Reply to this Message