adding a module with VBA

[maks25]

Hi,

I am creating a new workbook and am trying to imbed a macro as well as a button to call the macro. Does anyone know how to do that?

I already exported the module where the macro is as a BAS file

thank you

 

[VoG]

The easiest way would be to create a copy of a template file that already contains the code plus button.

Alternatively this may help http://www.cpearson.com/excel/VBE.aspx

 

[maks25]

Unfortunately I am creating the file out of thin air..

I tried this:

ThisWorkbook.VBProject.VBComponents.Import _
FileName:="G:\MACROS\BAS\TEST.bas"

However it did not seem to work

 

[maks25]

The error I get is "Programmatic access to Visual Basic Project is not trusted"

 

[VoG]

From the link that I posted

• Next, you need to enable programmatic access to the VBA Project. In Excel 2003 and earlier, go the Tools menu (in Excel, not in the VBA editor), choose Macros and then the Security item. In that dialog, click on the Trusted Publishers tab and check the Trust access to the Visual Basic Project setting.
  
  In Excel 2007, click the Developer item on the main Ribbon and then click the Macro Security item in the Code panel. In that dialog, choose Macro Settings and check the Trust access to the VBA project object model.

 

[maks25]

From the link that I posted

Lol I just figured it out the second I posted that reply haha.

works great now, thanks