View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aerojade Aerojade is offline
external usenet poster
 
Posts: 6
Default Running a macro from windows application

I need to run an Excel macro that is contained in the "ThisWorkbook" Module
of the file from a windows application. Can this be done. If so ...please
help me out with the code.

I tried OBJExcelWorkbook.Application.Run("MyMacro",missing ,missing......)
but it says macro cant be found. I think this is because it is inside
"ThisWorkbook". Please help.

Thanks