Close a workbook

M

Mike G.

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
mailto:[email protected]
 
T

Tom Ogilvy

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

or make SaveChanges:=True
 

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

populate a combobox based on unique values in another workbook 16
Say 'YES' to overwrite file 6
Opening a list of Excel files and run a macro in each 17
Ignoring a runtime error 1
Run macro on all files in a specific folder 3
closing another file by code causes failure to run workbook activate event 2
Open workbook(s) using VBA 2
Re-title multiple MS Project .mpp files at once 0

Top