Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error:-Creation of excel sheet
02-01-2012, 05:14 PM
Post: #1
Error:-Creation of excel sheet

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

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): "Set Excel=createObject("Excel.Application")".

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

Regards,
Shwetha
Find all posts by this user
Quote this message in a reply
02-01-2012, 08:42 PM
Post: #2
RE: Error:-Creation of excel sheet
(02-01-2012 05:14 PM)shwetha_m Wrote:  Hi,
Below is the script written for excel creation, when executing it displays error as:

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): "Set Excel=createObject("Excel.Application")".

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

Regards,
Shwetha

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

Basanth
QTP On Unix- Java Way - Without Putty or Terminal Emulation
You have no idea how high I can fly...
Find all posts by this user
Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  export values to the excel sheet rjkmr.aiht 7 287 05-04-2012 03:41 PM
Last Post: rjkmr.aiht
Cool Unable to import excel sheet to qtp shyams 5 2,319 04-22-2012 02:49 AM
Last Post: abhis786hek
  by using creation creation time we have to close the browsers mrajeshtnl 4 545 01-24-2012 11:27 PM
Last Post: mrajeshtnl
  Error While Exporting Excel Ankesh 8 989 11-03-2011 05:40 PM
Last Post: ravi.gajul
  Invalid procedure call or argument when using 2 excel sheet Uma 1 628 10-11-2011 04:04 AM
Last Post: Uma

Forum Jump:


User(s) browsing this thread: 1 Guest(s)