mithandir1 Posted November 19, 2013 Share Posted November 19, 2013 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. Link to comment Share on other sites More sharing options...
Solution water Posted November 19, 2013 Solution Share Posted November 19, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
mithandir1 Posted November 19, 2013 Author Share Posted November 19, 2013 Thanks. That is exaclty what i was looking for. Link to comment Share on other sites More sharing options...
water Posted November 19, 2013 Share Posted November 19, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now