Consulting

Results 1 to 1 of 1

Thread: Filling web form (little bit different)

  1. #1
    VBAX Newbie
    Joined
    Jan 2019
    Posts
    1
    Location

    Filling web form (little bit different)

    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!
    Last edited by andre133; 01-29-2019 at 12:45 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •