Read URL from excel file

[webanalytics 0]

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 20]

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.

[water 1,889]

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.