Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Another Book
Hi,
I wolud like to make a macro that when I open a book, will automatically open another book that I define. Can someone help me ??? Thank you in advance Ricardo Galveia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Another Book
Private Sub Workbook_Open() worksbooks.Open "C:\Myfiles\mybook.xls" End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Carpe Diem" wrote in message ups.com... Hi, I wolud like to make a macro that when I open a book, will automatically open another book that I define. Can someone help me ??? Thank you in advance Ricardo Galveia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Another Book
That should be
Private Sub Workbook_Open() Workbooks.Open "C:\Myfiles\mybook.xls" End Sub -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Phillips" wrote in message ... Private Sub Workbook_Open() worksbooks.Open "C:\Myfiles\mybook.xls" End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Carpe Diem" wrote in message ups.com... Hi, I wolud like to make a macro that when I open a book, will automatically open another book that I define. Can someone help me ??? Thank you in advance Ricardo Galveia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open new book (workbook) with other | Excel Discussion (Misc queries) | |||
Excel does not open Book | Excel Discussion (Misc queries) | |||
Book.xlt in doesn't open as default | Excel Discussion (Misc queries) | |||
personal book will not open | Excel Programming | |||
Open book, check for macros, close book | Excel Programming |