Q about exporting macros

[Guest]

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,

 

[Bernard Liengme]

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

 

[Guest]

Thank you. Works fine.

Best,
Mike
Jacksonville, Florida

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