Sign in to follow this  
Followers 0
levan

Variable must be of type object

6 posts in this topic

HI

I am fairly new to autoit

i dont know any programmimg languages

when i run example code of excelautomationtest.au3(from AutoIt3\Examples\COM)

shows an error "error creating excel object"

Share this post


Link to post
Share on other sites



First off, do you have Microsoft Excel installed?

And what version?


Challenge accepted!

Share this post


Link to post
Share on other sites

Microsoft Excel Starter 2010

Share this post


Link to post
Share on other sites

IIRC someone else had a similar problem some time ago with a trial version of Office. After installing the full product the problem went away.

It seems as if the trial versions of Office miss some features (COM support etc.)

According to Microsoft: "Office Starter consists of Microsoft Word Starter 2010 and Microsoft Excel Starter 2010 only, reduced functionality versions of Microsoft Word and Excel with advertising."


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

i installed microsoft excel 2007,

how can i find its Com objects and methode

Share this post


Link to post
Share on other sites

Check MSDN.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0