Closing Workbook without Questions

[Guest]

I have a spreadsheet macro running in Workbook 1, that opens Workbook 2,
manipulates some data, copies data from WB2 to WB1, and then closes WB2. How
do I get it to just close the workbook, without prompting me to save it with
changes?

Thanks,
John

 

[Guest]

as i recall some like:

ActiveWorkbook.Close savechanges:=True

 

[Norman Jones]

Hi John.

To close the workbook without saving any changes, try:

WB2.Close SaveChanges:= False

To close the workbook and save any changes, try:

WB2.Close SaveChanges:= True

 

[Guest]

Thanks, worked perfectly!

Hi John.

To close the workbook without saving any changes, try:

WB2.Close SaveChanges:= False

To close the workbook and save any changes, try:

WB2.Close SaveChanges:= True