Populate Web Form with macro

[Pedro Rodrigues]

Hello;

I have a problem after filling in some forms on specific third party site;

After filling in all fields and giving the order to save the info, the fields which had the correct info return to blank, and nothing gets saved on the web page...

I'm kind of new to this and cannot understand why or how to solve this small issue

Can anyone help me a little bit?
Thanks in advance;

Here's how my code looks like...

Sub testing()
Dim IE As Object
Set IE = CreateObject("INTERNETEXPLORER.APPLICATION")
IE.NAVIGATE Range("a1").Value

IE.Visible = True

While IE.BUSY
DoEvents

Wend
IE.Document.all("qi41").Value = ThisWorkbook.Sheets("Folha3").Range("a41")
IE.Document.all("imagelight").Click


End Sub

[noboffinme]

Hi Pedro Rodrigues,

I'm not sure what you're trying to do.

You say you're filling in a webform, so why would you be adding code to the 'front end' form?

Then your code belongs in the design view of the form, is that where your problem is?

If so, then exactly where?

Can you explain further?

[Pedro Rodrigues]

Well, I'm not a big code maker, but i will try to explain.

I have an excel file from which i want to take info and insert it on a third party web page, saving like this a lot of time for each report i have to fill in.
I started this from a code i found in the internet, and spent a lot of time working on it already, because i need to fill aproximatly 600 lines, 3 inputs for each line;
Basicly the info is numbers, that will generate a report, on the web page owner, after clicking the save button;

What happens is that in the original codeline, (working with google webpage) it inserts the data and works ok, but on my case, in the webpage i'm working, it inserts the data, but when you click for saving, all fields go blank, and no info gets saved...

I don't know how to explain it better; I thank you for your concern... Can you help me figuring out what is wrong on this?
Thanks in advance...