Micro Focus QTP (UFT) Forums
Open an populated Excel file - 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: Open an populated Excel file (/Thread-Open-an-populated-Excel-file)



Open an populated Excel file - mv8167 - 03-02-2012

I know to open a new Excel file, I must
Code:
Set oExcel = CreateObject("Excel.application")

But what does Set oExcel = when i want to open a previosly crerated?


RE: Open an populated Excel file - inborntester - 03-02-2012

after the above you should open workbook by below like code and remaining to read cells. (googe it)

Code:
Set oWorkbook = oExcel.Workbooks.Open(excelfilepath)