Jump to content
Sign in to follow this  
Curious52

Problem open Excel 2010

Recommended Posts

Curious52

I am using Windows XP and installed MS Office 2010, I am able to open Excel manually without any problem. But when I use AutoIt v3 with:

include <Excel.au3>
 
Local $f_Excel = "C:ExcelCapturesCapture_File.xlsx" 
 
Local $oExcel = _ExcelBookOpen($f_Excel)
 
MsgBox(0, "File Exiting", $oExcel)
 
It doesn't launch Excel 2010!
 
*) By the way, if Windows XP and I install MS Office 2003 the same codes above, it working fine!
 
 
Anyone can help?  o:)
 

 

Share this post


Link to post
Share on other sites
water

The Excel UDF that comes with AutoIt doesn't support the new file formats (xlsx).

Either save your files as filetype XLS or use my rewrite of the Excel UDF.

It is still an alpha version but I hope to soon release the first beta.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Curious52

Hi Water,

I did try to download & use ExcelEX, after extract all Excel files in my include   ... even I can launch Excel2010 with the Autoit now ... it has the error (please see the attach image), do you know why?

post-76616-0-43297100-1376335377_thumb.j

Share this post


Link to post
Share on other sites
water

If you use my Excel Rewrite UDF you have to use the AutoIt BETA version > 3.3.9.2.

You can install both the production and beta version in parallel.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Curious52

Hi Water again,

I am sorry that I have some kind of errors before, I have just re-write the codes and it launch successfully ... even it shows there is an errors (I selected option: continue anyways)

- Anyways, I will do as you just suggested

Many thanks for help  :bye:

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  

×