Filling web form (little bit different)

[andre133]

Hello guys,

first of all - I am amateur AF. Few dyas ago I´m discovered VBA and I would like to fill cells in our internal system. I don´t know how to tell you what I mean, better will be screens and description.

I have code from many websites. But I have some problem with errors (run-time 91 and 438).

Please can you help me, how to fill those cells?

This code - open IE, navigate to specific page, click on edit button


Sub test()
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.navigate "https://a700m330.autoexpr.com/prodetem/GridView.aspx?Table=tdms_evalcritresults&Test+Rep.+ID=285718&v=636839255146029462"
Do While .Busy Or _
.readyState <> 4
DoEvents
Loop
IE.Document.getElementById("DATAGRID_EDITCOLUMN_12_").Click
End With
Set IE = Nothing
End Sub



then I started to fill cells


Set DataCell = IE.document.getelementbyid("EDITCONTROL_11_30596726")
DataCell.Value = "value"

but there is some errors :(

I can´t understand those variables etc... please can you help me with this?

1. - CLICK ON EDIT
23647

CODE
23648

2. FILLING
23649

CODEs of cells

23650
23651


Can you please writte the right code or something?
Or will be fine the code for fillin the cells from excel sheet. (or .csv)
thank youuu so much for any help!