View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Calling a macro from a closed file

Hi Peter,

See the Run method and example in VBA help.


---
Regards,
Norman


"Peter" wrote in message
oups.com...
Hi all!

Does anyone know how to call a macro from a closed file and then run
that macro? I have tried recording it but no luck.

Any help would be much appreciated.

Peter