AnsweredAssumed Answered

vrf Date: Thu, 21 Mar 2002 16:26:40 +0100

Question asked by mwills on Mar 21, 2002
Hi All,
     Many thanks for all of the suggestions, especially the one below
which I used

ExcelApp.DisplayAlerts=FALSE;

As I said it's obvious when you know the answer and to make matters worse
I've used this command before and had forgotten it. That said I remember
last time I used it there were some problems when closing a template file in
this way. With the alerts turned off the workbook closed without an excel
prompt appearing as expected, however, a windows prompt sometimes appeared
informing the user that the file already existed and was a save required etc
and this couldn't be overridden. This part I didn't understand, maybe
somebody else can explain it.

Anyway, with hair intact, thanks again for the help,

Regards,
Mark Wills

Principal ATE Engineer
Wireless Automotive System Group

> * E-mail:  mwills@tycoelectronics.com
> * Phone: +44 (0)1908 574209 (direct line)
> * Phone: +44 (0)1908 574200 (switchboard)
> *  Fax:     +44 (0)1908 574300
>
Tyco Electronics UK Limited  M/A-COM Division
Featherstone Road
Wolverton Mill
Milton Keynes
MK12 5EW

Creating chaos out of order !

---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------

Outcomes