Posted to microsoft.public.excel.programming

waveracerr[_14_] waveracerr[_14_] is offline

external usenet poster

Posts: 1

Excel VBA-How to close all open workbooks except one specific?

Ah great, I somehow missed the code:

ThisWorkbook.Close SaveChanges:=True

Teach me not to just copy and paste....

Thanks

---
Message posted from http://www.ExcelForum.com/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
How to close all open workbooks in Excel 2007	Alojz	Setting up and Configuration of Excel	0	September 17th 09 11:04 PM
Workbooks Close, but window stays open	Mari	Excel Discussion (Misc queries)	2	January 16th 08 09:00 PM
Open Close workbooks	bbc1	Excel Discussion (Misc queries)	2	August 28th 05 11:24 AM
help with macro to open and close workbooks	aneurin	Excel Programming	1	September 24th 03 02:14 AM
Can I have a loop to open a set of workbooks get some data, close it one a time.	wellie	Excel Programming	2	July 9th 03 04:58 AM

All times are GMT +1. The time now is 03:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us