ExcelBanter - Close a workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Close a workbook (https://www.excelbanter.com/excel-programming/300078-close-workbook.html)

Mike G.

Close a workbook

Dear Gurus and Experts:

Another simple one for you.

I want to close a specific workbook that I have open after
a script is run.

The workbook name is 1RYGMstr ...

Would you please assist me with the coding that would be
required.

Best regards, Mike

Tom Ogilvy

Close a workbook

workbooks("1RYGMstr.xls").Close SaveChanges:=False

or make SaveChanges:=True

--
Regards,
Tom Ogilvy

"Mike G." wrote in message
...
Dear Gurus and Experts:

Another simple one for you.

I want to close a specific workbook that I have open after
a script is run.

The workbook name is 1RYGMstr ...

Would you please assist me with the coding that would be
required.

Best regards, Mike

All times are GMT +1. The time now is 10:37 PM.