Open Excel fiel if exist.

[rpaulson]

I have 2 excel files (Master.xls and tables.xls).
I want to tell my customers that they can keep them in whatever folder thy wish.
The customer is instructed to open Master.xls.

i want use Private Sub Workbook_Open() in Master.xls to automatically open tables.xls

How do I do this since I do not know the directory it may be in?

Ross

 

[ZVI]

Put this code into ThisWorkbook module of Master workbook:

Private Sub Workbook_Open()
  With ThisWorkbook
    If Dir(.Path & "\tables.xls") <> "" Then
      Workbooks.Open .Path & "\tables.xls"
    End If
  End With
End Sub

Another way without any macro - if tables.xls is already present then just set reference (via VBE-Tools-References) onto master.xls to the tables.xls.
Unique VBAProject name for tables.xls is required in this case via VBE - Tools - VBAProject Properties - Project Name (put unique name) - Ok

 

[rpaulson]

Thanks