View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lance Hoffmeyer Lance Hoffmeyer is offline
external usenet poster
 
Posts: 9
Default Running a Macro from hidden Workbook

I am running a app (SPSS) that does some Excel manipulations.

I have an Excel WOrkbook called macros.xls that opens up
hidden whenever Excel is started.

Running objExcel.App.Run "Macro" does not work while macros.xls
is hidden. If I unhide macros.xls then the line does work.

Is there a way to Run this macro without unhiding macros.xls
every time?

Lance