Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open workbook b when workbook a opened
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form to open when workbook is opened | Excel Worksheet Functions | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
my colors change in my workbook when I open another workbook | Excel Discussion (Misc queries) | |||
When I open a workbook, another one called Book1 is also opened. W | Excel Discussion (Misc queries) | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) |