AnsweredAssumed Answered

vrf Oh No not another Excel Problem !!

Question asked by mwills on Mar 21, 2002
Hi All,
     Many thanks for all of the suggestions, especially the one below
from Ralf and Marcus, 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