software

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 gt; macro gt; macros gt; edit,
or under tools gt; 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

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

quot;Mike Safferquot; gt; wrote in message
...
gt; Greetings,
gt;
gt; I have forgotten the best way to export a macro from one computer, then
gt; import it to another.
gt;
gt; Depending on where I am, either under tools gt; macro gt; macros gt; edit,
gt; or under tools gt; visual basic editor, I see two different files types,
gt; .cls
gt; and .bas.
gt;
gt; I always thought macros were .bas files, so that's why I'm writing.
gt;
gt; Let's say I have a macro in Personal.xls. What's the best way to copy it,
gt; and can I get a brief explanation between .cls and .bas?
gt;
gt; Much obliged,
gt; --
gt; Mike
gt; Jacksonville, Florida
Thank you. Works fine.

Best,
Mike
Jacksonville, Floridaquot;Bernard Liengmequot; wrote:

gt; Open VBA editor
gt; Click on each module in turn on the Project Window
gt; Use File | Export to send a BAS file to some folder
gt; ....
gt; Transfer folder to next PC
gt; ....
gt; Then
gt; Open VBA editor
gt; Select appropriate workbook in Project Window
gt; Use File | Import
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Mike Safferquot; gt; wrote in message
gt; ...
gt; gt; Greetings,
gt; gt;
gt; gt; I have forgotten the best way to export a macro from one computer, then
gt; gt; import it to another.
gt; gt;
gt; gt; Depending on where I am, either under tools gt; macro gt; macros gt; edit,
gt; gt; or under tools gt; visual basic editor, I see two different files types,
gt; gt; .cls
gt; gt; and .bas.
gt; gt;
gt; gt; I always thought macros were .bas files, so that's why I'm writing.
gt; gt;
gt; gt; Let's say I have a macro in Personal.xls. What's the best way to copy it,
gt; gt; and can I get a brief explanation between .cls and .bas?
gt; gt;
gt; gt; Much obliged,
gt; gt; --
gt; gt; Mike
gt; gt; Jacksonville, Florida
gt;
gt;
gt;