Macro opening firefox

[bono178]

Hello all
I apologise in advance for being a complete beginner. I tried to do some research but it all sounds like chinese which is not my best language unfotunately.
I will try to be as clear as I can

I want to have a macro that can operate in excel and it will open a page in firefox and fill it up according to the cells on the excel page

the content of the macro looks like this

TAG POS=1 TYPE=SELECT FORM=ID:edit_form ATTR=ID:lid CONTENT=%6552
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:edit_form ATTR=ID:xCoordInput CONTENT=A1
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:edit_form ATTR=ID:yCoordInput CONTENT=B1
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:edit_form ATTR=ID:t1 CONTENT=$C$1 (set before starting the macro)
TAG POS=1 TYPE=BUTTON FORM=ID:edit_form ATTR=ID:save

I guess I have to do some sort of loop to read every line of my excel doc ( about 200 lines ) to repeat the process for every A and B. And this is where I don't have a clue how to move on
I hope i'm making some sense and that someone can lead me in the right direction.
Thanks

 

[bono178]

up
Anybody got an idea?

 

[VBA Geek]

What is the page you need to fill? With which values?

 

[bono178]

Hello VBA Geek
It is for a game called travian
The page is : Travian fr6
the values will be numbers from -400 to 400 and they will represent the coordinate of a village (x and y)
i have a list of coordinates on a spreadsheet in 2 colums A and B (x and y) and I would like the macro to do a loop, filling the page with the coordinates and the number of soldiers ( preset in C1)

 

[VBA Geek]

It sounds feasible but I would have to peek into the HTML of the page and The site requires a username and password for logging in though, I cannot see the HTML of the page you would wanna fill up

 

[bono178]

do you wnat me to give you my login in private?

or i can send you a copy of the html file

 

[VBA Geek]

I'd need to have your log in to enter the site and then having a look at the page you want to fill and then see a spreadsheet with the values, then if possible we can start making a code