Importing Macros into Excel
 

I have some macros saved as .bas files that people need to be able to import
into their Excel. Their experience on importing is limited, so I need to be
able to explain to them how to import these files. Is there an easy way to
import the .bas files into Excel?

Thanks

Importing Macros into Excel
 

Might be easier for you to import them into a new workbook.

Save that workbook as an Add-in and give that to them.


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 08:26:00 -0700, Daren
wrote:

I have some macros saved as .bas files that people need to be able to import
into their Excel. Their experience on importing is limited, so I need to be
able to explain to them how to import these files. Is there an easy way to
import the .bas files into Excel?

Thanks

Importing Macros into Excel
 

Hi,

Copy a macro module to another workbook

1. Set the security level to Medium.

How?

A. On the Tools menu, click Options.
B. Click the Security tab.
C. Under Macro Security, click Macro Security.
D. Click the Security Level tab, and then select the security level you want
to use.

2. Open the workbook that contains the module (module: A collection of
declarations, statements, and procedures stored together as one named unit.
There are two types of modules: standard modules and class modules.) you want
to copy and the workbook you want to copy the module to.

3. On the Tools menu, point to Macro, and then click Visual Basic Editor.
4. On the View menu, click Project Explorer .
5. Drag the module you want to copy to the destination workbook.

Challa Prabhu
"Daren" wrote:

I have some macros saved as .bas files that people need to be able to import
into their Excel. Their experience on importing is limited, so I need to be
able to explain to them how to import these files. Is there an easy way to
import the .bas files into Excel?

Thanks