Sure, tryOn 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
Note - you only need one backslash (the board posts two for some reason).Code:Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks.Open FileName:="C:Updates.xls" End Sub
Regards,
_________________
Barrie Davidson
My Excel Web Page
[ This Message was edited by: Barrie Davidson on 2002-03-04 17:12 ]
Like this thread? Share it with others