View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default run macro from onoter Excel session

Hi,
I am tring to run a macro from another open workbook on another excel session.
I have tried using
Application.Run (PathToFile & "\" & NameOfFile & "!MacroName")
but the it open a new wotkbook (read only) and also get stuck.

Any idea,
Thanks