Jump to content
Sign in to follow this  
mithandir1

Use autoit on excel file that is already open.

Recommended Posts

mithandir1

Is it possible to read data from an excel file that is already open as opposed to reopening the .xlsm file  everytime I run the script?  The spreadsheet I am using is very complex and takes a considerable about of time to calculate  Everytime I edit the autoit script I am reopening the file and waitng for it to calculate and it is taking way too much time.  Does anybody have any suggestions?  Thanks.

Share this post


Link to post
Share on other sites
water

You can use the Excel UDF and try function _ExcelBookAttach. But make sure that the user doesn't edit a cell because the script will crash if you try to read this cell.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - 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
mithandir1

Thanks.  That is exaclty what i was looking for.

Share this post


Link to post
Share on other sites
water

If the functions of this UDF are too slow for you you could try my rewrite of the Excel UDF. It requires the beta version of AutoIt but is much faster than the "old" UDF.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - 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  

×