Micro Focus QTP (UFT) Forums
Closing the Excell sheet opened - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Closing the Excell sheet opened (/Thread-Closing-the-Excell-sheet-opened)



Closing the Excell sheet opened - tbull - 04-01-2010

Can any one please tell me how to close a excell sheet opened by qtp.it is working itf i give the coordinate of the window for drap and drop,but i want to close it without giving the position as the position may change depending on the screen resolution
Code:
'Window("regexpwndtitle:= 127621January.*","text:=Microsoft Excel.*").WinObject("NetUIHWND").Drag
'Window("regexpwndtitle:= 127621January.*","text:=Microsoft Excel.*").WinObject("NetUIHWND").Drop



RE: Closing the Excell sheet opened - manishbhalshankar - 04-01-2010

Hi Tbull,

Its preferable to use
PHP Code:
SystemUtil.CloseProcessByName("EXCEL.EXE"



RE: Closing the Excell sheet opened - tbull - 04-06-2010

Thank you for the help,the solution works
Its preferable to use
Code:
SystemUtil.CloseProcessByName("EXCEL.EXE")