Error:-Creation of excel sheet

Error:-Creation of excel sheet - 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: Error:-Creation of excel sheet (/Thread-Error-Creation-of-excel-sheet)

Error:-Creation of excel sheet - shwetha_m - 02-01-2012

Hi,
Below is the script written for excel creation, when executing it displays error as:

Code:
Set Excel=createObject("Excel.Application")

 Set ExcelSheet=createObject("Excel.sheet")

 ExcelSheet.Application.visible=true

Error : ActiveX component can't create object: 'Excel.Application'

Line (1):

Code:
"Set Excel=createObject("Excel.Application")".

please let me know what changes to be done to the script?

Regards,
Shwetha

RE: Error:-Creation of excel sheet - basanth27 - 02-01-2012

Shweta -
Just search for "Create Excel" on this forum and i guarantee you the solution you are looking for.