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

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

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