Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am writing an aplpication in VBA in Excel 2007. When i used to call a macro
under excel 2003 I could use: Application.run "XlaFile.xla!'VBAProject.ModuleName.MacroName" However when i try to use this construction under Excel 2007 i get the following error message: "Cannot run the macro 'XLAFile.xlam!VBAProject.ModuleName.MacroName'. The macro may not be available in this workbook or all macros may be disabled." The Macro is standing in the Workbook_Open event of my xlsm file and is calling an addin with xlam extension. The xlam file is selected in the add-in list. Does anybody have an idea how i can solve the problem? Can i continue using the Excel2003 way under Excel2007 or is the call of an macro out of an add-in changed under Excel2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro not working with XLAM add-in | Excel Programming | |||
How do I save a password protected .xlsm file containing old macro | Excel Programming | |||
Run xlsm Macro in the middle of night | Excel Programming | |||
Cannot run the macro 'LOOKUP.XLAM!GetLookup | Excel Discussion (Misc queries) | |||
call to macro in xlam from macro in xlsb | Excel Programming |