2011 21:29
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to close many files at a time
On 12/3/11, Amit Desai (MERU) wrote:
> 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
On 12/3/11, Amit Desai (MERU) wrote:
> 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: Thi
HI Amit,
Hold the "Shift" key and Press the CLOSE button (Right side upper corner).
Links:
http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=86
http://www.accountingweb.com/item/107361
Regards,
MARIES.
+971559828492
On Sat, Dec 3, 2011 at 6:13 PM, dguillett1 wrote:
> This a
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
W
