close and open a Workbook with a macro button click

Hi there I've been trying to code a macro to save a workbook on close. and then open a workbook on My Documents and update data.

E.G.
Book1; data is inputted to cells.
Click button

on button click
close document
save changes
open Book2
update data links

This is the VB code I have so far;

Private Sub CommandButton1_Click()

ActiveWorkbook.Save
ActiveWindow.Close
'Refers to Book1
Workbooks.Open Filename:= _
"C:\Users\Documents\Book2.xls", _
UpdateLinks:=0

Windows("Book2").Activate
End Sub

However when I run the macro it only closes the first sheet and does not open the second.
Please help.

The issues is once the book closes the macro stops so you have to open the other workbook befroe tou close so try this:

Please Login or Register  to view this content.

Thanks for the tip however I books 1 and 2 are linked. I want the data inputted to Book1 to be so bed and then Book2 to be opened and linked cells updated.

Sent from my GT-I9300 using Tapatalk

As above... open other workbook first, then close. You can't run a macro when the book that contains the macro is closed.

Please Login or Register  to view this content.