webanalytics Posted September 27, 2012 Share Posted September 27, 2012 Hello all and thank you in advance, This is what I am trying to do: 1. Open Excel file 2. Read a cell - the cell will include a URL 2a. the URL above is dynamic (has start date and end date <- will be handled by excel macro) 3. Paste the url into IE or firefox (url is an API url for a CSV file 4. Download the file and save it to my hard drive. Thank you so much in advance, Link to comment Share on other sites More sharing options...
Myicq Posted September 27, 2012 Share Posted September 27, 2012 How far did you get ? Looking at the included help file examples, and the examples for f.ex and (now also in help files) should actually give the solution.Your job should be doable in some 20 lines.It's always a good idea to try first. Then ask for help. I am just a hobby programmer, and nothing great to publish right now. Link to comment Share on other sites More sharing options...
water Posted September 27, 2012 Share Posted September 27, 2012 As Myicq has stated everything should be doable with AutoIt functions (hint: Excel and IE UDF - check the help file). What we need is a question and the code you have written so far. 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