Use a macro to open another woorkbook?

[Wrecker]

Is there cade I can put in the Beforeclose module of a workbook, to open another woorbook?

workbook.open c:Updates.xls

Thanks
Wrecker

[Barrie Davidson]

On 2002-03-04 17:05, Wrecker wrote:
Is there cade I can put in the Beforeclose module of a workbook, to open another woorbook?

workbook.open c:Updates.xls

Thanks
Wrecker

Sure, try

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks.Open FileName:="C:Updates.xls"
End Sub

Note - you only need one backslash (the board posts two for some reason).

Regards,

_________________

Barrie Davidson
My Excel Web Page

[ This Message was edited by: Barrie Davidson on 2002-03-04 17:12 ]

[Anne Troy]

You can record that macro. Store it in the Workbook, then rename it. Here's the code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks.Open Filename:="C:WINDOWSDesktopMyfile.xls"
End Sub