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
RU)
> *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
>
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$
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 info