Workbook #1 wants workbook #2 open when you open #1?

You could open workbook #2.
Hit alt-f11 to get to the VBE.
Click on workbook #2' project.
It should look like: VBAProject (Workbook2.xls)
Hit F4 to see the properties window

Change the (Name) property to something nice and unique (not VBAProject).

Maybe the name of the workbook (nicely truncated)????

Save that workbook.

Back to excel to open workbook #1
back to the VBE (alt-f11)
click on workbook #1's project
then Tools|references
select the project for workbook #2.

Back to excel and close both (remember to save workbook #1).

Now open workbook #1. Since you have a reference to #2, it'll be opened when #1
opens.

=========
Alternatively, you could use a macro that tries to open workbook #2.

Option Explicit
Sub Auto_open()

Dim tstWkbk As Workbook
Set tstWkbk = Nothing
On Error Resume Next
Set tstWkbk = Workbooks("workbook2.xls")
On Error GoTo 0

If tstWkbk Is Nothing Then
On Error Resume Next
Set tstWkbk = Workbooks.Open(Filename:="C:\my documents\workbook2.xls")
On Error GoTo 0
If tstWkbk Is Nothing Then
MsgBox "File not found!"
End If
End If
End Sub

Change the names.


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!

--

Dave Peterson