autotune Posted July 16, 2014 Posted July 16, 2014 (edited) Hello, I just want to start saying that I "was born yesterday" to Autoit. I have found little things I can do with it but the big things like doing repetitive tasks are seem easy in thought but since i dont know the language very hard to perform. With that said here is what i need to do with my task at hand that involves over 200 documents. Doing this manually would take loads of time that i dont have and i also thought that this could be a tutorial for me for future purposes First off, I have an excel spreadsheet that has the list of documents i need to retrieve from another program (Smart Plant Foundation). I basically need comb thru each document name (1 by 1 down the list) and search for that same document name in SPF to download that file. Sounds simple enough? No... SPF is very pick on how you obtain files. I would have to search the document name first and then right click on the file, scroll to file, then choose save target as and select a location to save the target. Please help!!! Let me know if you need more of an explanation as I usually leave a few details out! Please take a look below at my the example Edited July 16, 2014 by autotune
water Posted July 16, 2014 Posted July 16, 2014 To read Excel into an array which you then can loop through I suggest to check function _Excel_RangeRead that comes with the latest version of AutoIt. 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
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