open workbook b when workbook a opened
 

open workbook b when workbook a opened
 

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


On Mon, 21 Jul 2008 09:41:02 -0700, uk
wrote:

open workbook b when workbook a opened
 

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


"Gord Dibben" wrote:

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


On Mon, 21 Jul 2008 09:41:02 -0700, uk
wrote:

open workbook b when workbook a opened
 

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

Entered in Thisworkbook module of workbook ts


Gord

On Mon, 21 Jul 2008 23:15:00 -0700, uk
wrote:

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


"Gord Dibben" wrote:

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


On Mon, 21 Jul 2008 09:41:02 -0700, uk
wrote:

open workbook b when workbook a opened
 

many thanks

"Gord Dibben" wrote:

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

Entered in Thisworkbook module of workbook ts


Gord

On Mon, 21 Jul 2008 23:15:00 -0700, uk
wrote:

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


"Gord Dibben" wrote:

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


On Mon, 21 Jul 2008 09:41:02 -0700, uk
wrote:

open workbook b when workbook a opened
 

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 FileSave Workspace as yourname.xlw

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


Gord

On Tue, 22 Jul 2008 06:42:31 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

Entered in Thisworkbook module of workbook ts


Gord

On Mon, 21 Jul 2008 23:15:00 -0700, uk
wrote:

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


"Gord Dibben" wrote:

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


On Mon, 21 Jul 2008 09:41:02 -0700, uk
wrote: