This assumes you have a list of files entered in cells and have used ctrl to
select the file(s) to close
You can use another macro to make the list if not there
Sub CloseSelectedWorkbooks()
On Error Resume Next
Application.DisplayAlerts = False
For Each wb In Selection
workbookname = wb.Value
Windows("" & workbookname & ".xls").Close
Application.DisplayAlerts = True
Next wb
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Saturday, December 03, 2011 7:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to close many files at a time
Hi All,
In case if i want to close many excel files (& not all) or emails all at a time
(in stead of selecting one at a time – want to select many..), how can we do
that?
Regards,
Amit Desai
--------------------------------------------------------------------------------
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not the addressee indicated in this
message (or authorized to receive for addressee), you may not copy or deliver
any part of this message or its attachments to anyone or use any part of this
message or its attachments. Rather, you should permanently delete this message
and its attachments (and all copies) from your system and kindly notify the
sender by reply e-mail. Any content of this message and its attachments that
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be
taken not to have been sent or endorsed by any of them. Email communications
are not private and no warranty is made that e-mail communications are timely,
secure or free from computer virus or other defect.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
