Close worksheet, dont save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a macro in file A that opens file B , copies some data from it, pastes
it to file A, then closes file B.

when it closes file B, i dont want it to save changes.

i can find the command that WILL Save it (ActiveWorkbook.Save), & am
currently using the command to not save it (ActiveWorkbook.Close), however it
always brings up the "Do you want to save changes?" tick box in the middle of
the macro.

how do i get round this? is there a command to say 'close, no changes'?

cheers


jb
 
Hi jb,

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True

Regards,

OssieMac
 
cheers, OssieMac

works a treat!

jb

OssieMac said:
Hi jb,

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True

Regards,

OssieMac
Click to expand...
 

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

automation error when closing excel 3
VB Syntax to close Excel workbook not saving changes 1
Save BeforeClose 1
Saving Workbook with Password using SaveChange 2
Closing a file with macros 4
Excel Macro Problem 2
Button looses Macro setting when running Macro 1
Addin not allowing thisworkbook.save in before save event 3

Back
Top