Micro Focus QTP (UFT) Forums
Excel Report Automation - 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: Excel Report Automation (/Thread-Excel-Report-Automation)



Excel Report Automation - Sathiyakum - 06-24-2011

All,

My application generates a runtime excel report and I am using the below code

Code:
Set myexl=getobject(, "Excel.Application")

But I am getting an error while saving and running the script.

Error: Expected expression
QTP version: 11

Could someone please help me solve this error.

Thanks,
Sathiya


RE: Excel Report Automation - rajpes - 07-05-2011

Code:
Set myexl=getobject(, "Excel.Application")

Shouldnt it be
Code:
Set myexl=[b]CreateObject[/b]("Excel.Application")