open new workbook after closing current workbook (VBA/Excel 2000)

Topic

New Reply

Is there a way to programmatically close the currently running workbook, then open another workbook and run the Auto_Open macro in it? It seems like one of the events ought to let me do this.

Reply | Quote

Replies

If the code is NOT in the active workbook:

Activeworkbook.Close SaveChanges:=False
Workbooks.Open “c:datatest.xls”
Activeworkbook.RunAutoMacros xlautoopen

Reply | Quote