AnsweredAssumed Answered

AW: vrf Oh No not another Excel Problem !!

Question asked by bernhardt on Mar 20, 2002
Hi Mark,

did you try to switch off EXCEL error messages with
xlapp.DisplayAlerts=FALSE?

Best regards
M. Bernhardt
-----------------------------------------
Somatec B. Aufenanger & M. Bernhardt
Jagdweg 7a
D-82041 Deisenhofen

Telefon     : (089) 613 984 94
Fax         : (089) 613 981 23
Email       : mailto:Bernhardt@somatec.de
Homepage    : http://www.somatec.com/
-----------------------------------------


-----Ursprngliche Nachricht-----
Von:      Wills, Mark [mailto:MWills@tycoelectronics.com]
Gesendet:     Mittwoch, 20. Mrz 2002 15:47
An:     Vee Reflector (E-mail)
Betreff:     vrf Oh No not another Excel Problem !!

Hi All,

     Please can somebody help me while I still have some hair left.

I have two workbooks open and wish to copy some raw plot data from book 2 to
a template document in book 1, this is simple enough and works fine.
I now want to close the second workbook containing the raw data without
saving the changes, again this seemed simple enough using the command

ExcelApp.Workbooks(myfilename).Close(False);

However the user is prompted each time that there is a large amount of data
on the clipboard is this data required YES / NO etc.
The problem appears to be that the range I have copied from book 2 is still
selected (with dashed lines indicating a cut/copy), I guess that if I could
somehow deselect this range programmatically then this prompt would not
appear and the workbook would close as it should.

Whatever I seem to do to try to get around this has so far met with failure
e.g. selecting another cell or range within that worksheet.

Any help would be gratefully appreciated, an example of the required code
would be even better.

I'm sure the solution is simple but I just can't see it, thanks in advance.


Regards,
Mark Wills

Principal ATE Engineer

> * 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