Thread: Auto Open Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Auto Open Macro

If I understand the question correctly you want the spreadsheet to (without
being open) "listen" for the target file being opened, and then open itself,
which it just can not do. There are a couple of alternatives.

You could set it up that when you open the Excel file the other file will
open, or you could use a batch file as a shortcut to open both files
simultaneously.
--
HTH...

Jim Thomlinson


"Kasey Kern" wrote:

Hi,

I have a spreadsheet that I want to open automatically when I open a
specific file. I'm not sure how to do that. Any help would be appreciated!

Thanks!