Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Report Automation
#1
Solved: 11 Years, 4 Months ago
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
Reply
#2
Solved: 11 Years, 4 Months ago
Code:
Set myexl=getobject(, "Excel.Application")

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


Possibly Related Threads…
Thread Author Replies Views Last Post
  Report Viewer showing hundreds of WebElement.Exists? themoon 1 2,336 03-09-2016, 02:43 PM
Last Post: vinod123
  where can I find the help for excel & database automation abhi_biradar2006 0 1,959 05-20-2014, 01:08 AM
Last Post: abhi_biradar2006
  QTP 11.0 Doesn't allow to save excel extracted from BO report. Hema Ganesh.M 1 3,230 12-09-2013, 07:32 AM
Last Post: basanth27
  Warning in Report profqa 2 4,447 12-06-2013, 10:12 AM
Last Post: profqa
  QTP Report to respective QC test Set Path through VBS Anand Saboo 0 2,413 11-01-2013, 02:36 PM
Last Post: Anand Saboo

Forum Jump:


Users browsing this thread: 1 Guest(s)