webanalytics Posted September 27, 2012 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,
Myicq Posted September 27, 2012 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.
water Posted September 27, 2012 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 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