How can I open web pages from excell

[GiuseppeBC]

Hi, I am not informatic, and I don't know about programation.

I open this post becouse I need to help in order to write a simple codec.

I have an excell file (the file name is: url.xlsx). In this files, in the sheet 1, there is in the "COLUMN A" one list of 600 url (cell A1, cell A2, ... cell A600).

So I need to do the following:

1.1: To open url of cell A1

1.2: To position mouse during 1 second in a especial coordinate that I have named "X1,Y1"

1.3: To do clic with left buttom in the coordinate "X1,Y1"

1.4: To do clic with left buttom in the coordinate "X2,Y2"

1.5: To close internet explorer tab

2.1: To open url of cell A2

2.2: To position mouse during 1 second in a especial coordinate that I have named "X1,Y1"

2.3: To do clic with left buttom in the coordinate "X1,Y1"

2.4: To do clic with left buttom in the coordinate "X2,Y2"

2.5: To close internet explorer tab

.... 

600.1: To open url of cell A600

600.2 To position mouse during 1 second in a especial coordinate that I have named "X1,Y1"

600.3: To do clic with left buttom in the coordinate "X1,Y1"

600.4: To do clic with left buttom in the coordinate "X2,Y2"

600.5: To close internet explorer tab

 

I don't know how to do that.

In resume the action is to open a web, and to do 2 clics, and to close the tab...

Is there sameone that can write the codec in order to do that?

Thank's very much for your support.

 

[MikahS]

You can use the Excel UDF to easily focus cells and go from there with the IE functions. Give it a try and post what you come up with.

Edited June 29, 2015 by MikahS
link