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
screen1.JPG
CODE
screenedit.JPG
2. FILLING
screen2.JPG
CODEs of cells
screen3.JPG
rolldownscreen.JPG
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!