Consulting

Results 1 to 1 of 1

Thread: Web Form Fill via EXCEL VBA-Cant find ID or anything to fill date

  1. #1
    VBAX Regular
    Joined
    Sep 2018
    Posts
    23
    Location

    Talking Web Form Fill via EXCEL VBA-Cant find ID or anything to fill date

    i am very new to this kind of project could you help me to identified ID or Tag to fill this value via VBA Excel.I was trying to in different way many times.

    Date.jpg
    Sub automaticformfilling()

    Dim ie As InternetExplorer
    Dim doc As MSHTML.HTMLDocument







    Set ie = CreateObject("internetexplorer.application")


    With ie
    .Visible = True
    .navigate "xxxxxx"
    'Wait for loading
    Do While .Busy
    DoEvents
    Loop


    Do While .readyState <> 4
    DoEvents
    Loop


    End With
    Set doc = ie.document
    Set fname = doc.getElementById("j_username")
    fname.Value = "xxxx"




    Set lastName = doc.getElementById("j_password")
    lastName.Value = "xxxx"


    doc.getElementsByName("btn_submit")(0).Click


    'Set doc = ie.document
    'Set invdate = doc.getElementsByClassName("GHNF1GMDEI")
    'invdate.Value = "25"






    Set refname = doc.getElementsByName("GHNF1GMDGM")








    '.doc.getElementsByClassName ("GHNF1GMDGM")






    refname.Value = "923456"

    Attached Images Attached Images

Posting Permissions

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