View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to call startup folder vba function?

Application.Run "Startup.xls!Macro1"

--
Regards,
Tom Ogilvy

Tom Corcoran wrote in message
...
I have a xls file loading hidden from my alternate startup folder.

After a lot of help file reading, hunting and web searching I can't figure
how to call a vba routine I have defined in the startup xls in another xls
file. Can someone please let me in on the secret.

Thanks a lot,

Cheers - Tom.