View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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: