Thanks for responding. I wanted spreadsheet B to open when I opened
spreadsheet A. I used the following code and it worked..

Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\B.xls"
End Sub

Thanks!

"Jim Thomlinson" wrote:

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!