water Posted June 30, 2015 Share Posted June 30, 2015 I modified the above code. _Excel_BookOpen was missing and _Excel_Open was wrong. 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 Link to comment Share on other sites More sharing options...
blass9 Posted June 30, 2015 Author Share Posted June 30, 2015 water,Yahoo! It works! You are the most awesomest of awesome!I had to put in an extremely brief pause to give the Excel program time to open on my slow computer:Local $aFileList = _FileListToArray(@DesktopDir, "*.xlsm", 1, True) Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel, $aFileList[1]) Sleep(10) Local $filename = _Excel_RangeRead($oWorkbook, Default, "C13") ;Reads filenameOtherwise the script wanted to start passing data before it was fully open and messed up the order.Thank you! Link to comment Share on other sites More sharing options...
water Posted June 30, 2015 Share Posted June 30, 2015 I wonder why a Sleep statement is needed because _Excel_RangeRead should only start when _Excel_BookOpn has finished. There is no asynchronous processing.Nevertheless, it works for you 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 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