Sign in to follow this  
Followers 0
webanalytics

Read URL from excel file

3 posts in this topic

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,

Share this post


Link to post
Share on other sites



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.

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0