Jump to content

Recommended Posts

Posted

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:)
 

 

Posted

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 (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Posted

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

Posted

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 (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Posted

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:

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
×
×
  • Create New...