+- 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: ActiveX component can't create object: 'Excel.application' (/Thread-ActiveX-component-can-t-create-object-Excel-application)
ActiveX component can't create object: 'Excel.application' - RGummadidala - 01-29-2011
Hello All,
I'm a newbie in QTP and scripting. After looking at some examples over internet in accessing excel through VBscript, I started writing code like below
Code:
CreateObject("Excel.Application")but ended up with the error 'ActiveX component can't create object: 'Excel.application'". I know that the issue is with some missing or unregistered dlls in the system, as I was successful in creating InternetExplorer object.
I'm using Windows 7 Home edition and Microsoft Home 2010 edition. Can someone help me to find the correct dll and the process to registe the same.
Thanks
RE: ActiveX component can't create object: 'Excel.application' - manishbhalshankar - 01-31-2011
Hi RGummadidala,
The above method is working for me. No issues..
Have you installed Office 2010 as "Click-to-run"?
Please check this link.
RE: ActiveX component can't create object: 'Excel.application' - RGummadidala - 02-02-2011
Hi Manish,
In my system, I see that Microsoft Office Click-to-Run 2010 is installed (atleast I see that in control panel). Now, I'm not sure what it is? Should there be any other way the objects need to be created, if that is in 'Click-to-run' and more over, how to check if the apps are actually running as 'Click-to-Run'
Thanks
RGummadidala
Also, I'm working using the "web" add-in. Do I need to check in the box for "Active-X", for this to work.
RE: ActiveX component can't create object: 'Excel.application' - sandya - 09-06-2012
jest i wrote below four lines of code
it though error ==================
The test run cannot continue due to an unrecoverable error.
ActiveX component can't create object: 'Excel.Application'
Code:
Line (1): "".
==================================
Dim XLApp
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
Wait(5)