Thread: open workbook b when workbook a opened
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] uk swain.s@blueyonder.co uk is offline
external usenet poster
  
Posts: 64
Default 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:





Reply With QuoteReply With Quote