tag:blogger.com,1999:blog-905635426968946071.post4537656655012403599..comments2024-02-20T15:49:36.797+05:30Comments on Software Testing tips: Closing Excel instance by VBScriptChitra Palanihttp://www.blogger.com/profile/03582068733019864689noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-905635426968946071.post-5122308103941222362014-05-17T20:21:38.589+05:302014-05-17T20:21:38.589+05:30I've seen a lot of functions supposed to close...I've seen a lot of functions supposed to close Excel. This one is the only that do work.<br />Thank you very much!!!Pete Shifterhttps://www.blogger.com/profile/00488894205456165708noreply@blogger.comtag:blogger.com,1999:blog-905635426968946071.post-91928424397463657802009-09-24T06:58:15.346+05:302009-09-24T06:58:15.346+05:30Hey,
Can you add following lines instead of savin...Hey,<br /><br />Can you add following lines instead of saving file and try it?<br /><br />objExcel.Application.DisplayAlerts = False<br />objExcel.ActiveWorkbook.Saved = False<br /><br />For multiple instances, you can put a FOR loop.Palani Selvamhttps://www.blogger.com/profile/03262468619435099477noreply@blogger.comtag:blogger.com,1999:blog-905635426968946071.post-69757636987620273692009-09-24T02:16:52.098+05:302009-09-24T02:16:52.098+05:30Hi Just tried the above code for closing an excel ...Hi Just tried the above code for closing an excel instance with multiple excel files open. I go the same message as posted above. <br />what would be the solution in this case.. thanks in advance..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-905635426968946071.post-81503043592782593422009-07-16T22:00:55.970+05:302009-07-16T22:00:55.970+05:30It should work fine. I have the same steps and wor...It should work fine. I have the same steps and working fine. You should check, whether you have VBScript5.7 engine and Office 2k3 SP3.Palani Selvamhttps://www.blogger.com/profile/03262468619435099477noreply@blogger.comtag:blogger.com,1999:blog-905635426968946071.post-87540049680589244822009-07-14T14:07:20.524+05:302009-07-14T14:07:20.524+05:30I tried the vbs code, but its not closing the exce...I tried the vbs code, but its not closing the excel and giving message that FAIL. Excel application is not closed properly.<br /><br />Steps I followed:<br />1. Copy the code from blog.<br />2. Save it as killExcel.vbs.<br />3. Open new excel 2007<br />4. Double click on vbs file.<br /><br />Let me know if I am missing something here.Anonymousnoreply@blogger.com