Jump to content
Sign in to follow this  
GiuseppeBC

How can I open web pages from excell

Recommended Posts

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.

 

Share this post


Link to post
Share on other sites
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 by MikahS
link

Snips & Scripts


My Snips: graphCPUTemp ~ getENVvars
My Scripts: Short-Order Encrypter - message and file encryption V1.6.1 ~ AuPad - Notepad written entirely in AutoIt V1.9.4

Feel free to use any of my code for your own use.                                                                                                                                                           Forum FAQ

 

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  

×