open workbook b when workbook a opened

[swain.s]

 

[Gord Dibben]

Stick this code into Thisworkbook module of workbook a

Private Sub Workbook_Open()
Workbooks.Open Filename:= "C:\your path to\b.xls"
End Sub


Gord Dibben MS Excel MVP

 

[swain.s]

hello i have tried this & it does not work
the name of workbook (b) is data & workbook is (ts)

 

[Gord Dibben]

Private Sub Workbook_Open()
Workbooks.Open Filename:= "C:\your path to\data.xls"
End Sub

Entered in Thisworkbook module of workbook ts


Gord

 

[swain.s]

many thanks

Private Sub Workbook_Open()
Workbooks.Open Filename:= "C:\your path to\data.xls"
End Sub

Entered in Thisworkbook module of workbook ts


Gord

 

[Gord Dibben]

If you are still around, now that I have had my afternoon nap, I could
suggest an alternate solution without code.

Open both books and File>Save Workspace as yourname.xlw

They will now open together when you select the yourname.xlw file


Gord