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

as i recall some like:

ActiveWorkbook.Close savechanges:=True

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


---
Regards,
Norman



"John Viall" wrote in message
...
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

Thanks, worked perfectly!

"Norman Jones" wrote:

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


---
Regards,
Norman



"John Viall" wrote in message
...
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