Micro Focus QTP (UFT) Forums

Micro Focus QTP (UFT) Forums > Micro Focus UFT (earlier known as QTP) > UFT / QTP Beginners > Closing a specific Excel file
Full Version: Closing a specific Excel file
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

mv8167

08-19-2011, 02:09 AM
Is there a easy way to close a specific Excel file? I can close all of them, I just cant seem to close one file.

thx everyone ;-)

sshukla12

08-19-2011, 11:34 AM
Try this:

Code:
Set excel=CreateObject("Excel.Application")
excel.visible=true
set obj_excel=excel.workbook.open(<Enter the path for ur excel file>)
like this u can open many excel files but use the reference to close any particular file.
obj_excel.close()

Correct me if wrong.

Regards,
Sankalp

mv8167

08-19-2011, 08:33 PM
Sankalp.

Thx, I guess In was just tired. Was up since 1:30am with a Prod issue. Thx, i am clear now.

Lor
Micro Focus QTP (UFT) Forums > Micro Focus UFT (earlier known as QTP) > UFT / QTP Beginners > Closing a specific Excel file