Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open second workbook
how does one open a second workbook automatically
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open second workbook
press ALT+F11
double-click on ThisWorkbook module you should see two windows to the right 1. (General) and 2. (Declarations) click on 1. (General) and select Workbook in 2. select "Open" from the list of events the result should be: Private Sub Workbook_Open() End Sub in between those 2 lines paste the following code: Workbooks.Open "SECONWORKBOOK.XLS" so the resultant macro should read: Private Sub Workbook_Open() Workbooks.Open "C:\Documents and Settings\Swain\Desktop \SECONWORKBOOK.XLS" End Sub adjust "SECONWORKBOOK.XLS" and "C:\Documents and Settings\Swain\Desktop \" (the file's path) accordingly On 17 Sty, 08:41, uk wrote: how does one open a second workbook automatically |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |