Q about exporting macros
 

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,
--
Mike
Jacksonville, Florida

Q about exporting macros
 

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

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

"Mike Saffer" wrote in message
...
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,
--
Mike
Jacksonville, Florida

Q about exporting macros
 

Thank you. Works fine.

Best,
Mike
Jacksonville, Florida


"Bernard Liengme" wrote:

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

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

"Mike Saffer" wrote in message
...
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,
--
Mike
Jacksonville, Florida