Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
workbook before close mohavv Excel Discussion (Misc queries) 2 November 21st 07 01:27 AM
close only one workbook bobsmom70601 New Users to Excel 1 March 8th 05 09:43 PM
How can I close a workbook using VBA? Trevor[_4_] Excel Programming 2 March 2nd 04 01:12 AM
Close Workbook Programmatically Lucy[_2_] Excel Programming 3 December 30th 03 08:17 PM
cannot close workbook chrisneill Excel Programming 3 July 13th 03 11:10 PM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"