prompt to save when already saved

S

Scooter

I have a macro in a blank workbook that opens, updates and closes other
workbooks. The below 3 lines are what I repeat for the files to update.
Why do I still get the "Do you want to save your changes..." prompt when it
closes a file?

Workbooks.Open Filename:="aaa.xls", UpdateLinks:=True
Workbooks("aaa.xls").Save
Workbooks("aaa.xls").Close
 
J

John Bundy

works for me, you can try the save and false for saving changes since you
already did
Workbooks("aaa.xls").Close (False)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open four Wbooks, copy four columns from each to Master Wbook 16
Save As and new workbook new name used in existing code 8
All Workbook Saved except This Workbook 3
Suppressing a screen 2
Similar Book to Book Code, one works other does not 11
display alerts= false not working 2
Excel crashes and restarts when accessing newly created worksheet 2
UserForm problem 2

Top