Close a the current workbook and load another specified workbook

[Adrian]

Hi,

How do we code in VBA to close the current workbook and load another
specifed one?

For example, I am currently in ABC.xls and I wish to close this workbook and
load DEF.xls....

 

[Bob Phillips]

Activeworkbook.Close
Workbooks.Open filename:="C:\myDir\DEF.xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[David]

Bob Phillips wrote

Activeworkbook.Close
Workbooks.Open filename:="C:\myDir\DEF.xls"

Will the second line really execute if the calling file is closed?

 

[Dave Peterson]

If the code isn't in the activeworkbook, it'll work ok.

(I'm guessing that there's a 3rd workbook controlling the action.)

 

[Chip Pearson]

Adrian,

Try something like

Sub AAA()
Workbooks.Open "DEF.xls"
Workbooks("ABC.xls").Close savechanges:=True
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com