This should do, but it also quits Excel.
Â
myAppl.DisplayAlerts = false;
myAppl.Quit();
-----Message d'origine-----
De : James Zhang [mailto:James.Zhang@rfsworld.com]
Envoyé : 21 juillet 2006 03:00
How do i use Close method to close an opened excel file without saving the changes?
I tried with like App.Workbooks.Close(FALSE, filename,FALSE) then i got error message.
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Â
myAppl.DisplayAlerts = false;
myAppl.Quit();
-----Message d'origine-----
De : James Zhang [mailto:James.Zhang@rfsworld.com]
Envoyé : 21 juillet 2006 03:00
How do i use Close method to close an opened excel file without saving the changes?
I tried with like App.Workbooks.Close(FALSE, filename,FALSE) then i got error message.
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".