Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbooks when opening an excel file
I have 2 workbooks- workbook A contains a master job list and workbook contains employees time allocated on a job. The master job lis (workbook A) changes often so I have created a link between the workbooks. I would like to create a macro that will open workbook when I open workbook B. I assume I would put this in the open workboo event -- jprogramme ----------------------------------------------------------------------- jprogrammer's Profile: http://www.excelforum.com/member.php...fo&userid=2978 View this thread: http://www.excelforum.com/showthread.php?threadid=54686 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbooks when opening an excel file
Private Sub Workbook_Open()
workbooks.Open "C:\MyFolder\Workbook B.xls" End Sub go into the VBE (alt + F11), then in the project explorer on the left, select your workbook and double click on the ThisWorkbook entry under your project. this should open the thisworkbook module. At the top of the module, in the left dropdown select Workbook and in the right down select Open. Modify at the second line above (adjusted for your specifics). -- Regards, Tom Ogilvy "jprogrammer" wrote: I have 2 workbooks- workbook A contains a master job list and workbook b contains employees time allocated on a job. The master job list (workbook A) changes often so I have created a link between the 2 workbooks. I would like to create a macro that will open workbook A when I open workbook B. I assume I would put this in the open workbook event? -- jprogrammer ------------------------------------------------------------------------ jprogrammer's Profile: http://www.excelforum.com/member.php...o&userid=29781 View this thread: http://www.excelforum.com/showthread...hreadid=546863 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
how do i stop 16 workbooks from opening when I open excel 2007? | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
when opening an excel file, two files open | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |