View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLDommel CLDommel is offline
external usenet poster
 
Posts: 2
Default How to call a macro from a xlam in a xlsm

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