Hi Guys!
Good Day!
I'm new to the VBA world, I have managed to crawl some simple html web page, but I find it difficult to crawl sap BI4 webpage.
Is there anyone there who can help me log in to the website?
I use excel 2013
elements are attached.
Hi Guys!
Good Day!
I'm new to the VBA world, I have managed to crawl some simple html web page, but I find it difficult to crawl sap BI4 webpage.
Is there anyone there who can help me log in to the website?
I use excel 2013
elements are attached.
Welcome to the forum,
Did you try according to this scheme ?
What was happening, what were the (error) messages ?
But "section" '<div class="logonButton">' has not been expanded and cannot see what is there, maybe the confirmation button has a different name (?).![]()
Option Explicit Sub logo_gino_onig_ogol() Const usrnme = "yellow panther" Const psswrd = "pink submarine" Dim mmnt! Dim strUrl$ Dim ie As Object strUrl = "https://www.www.www.html" '<= website Set ie = CreateObject("InternetExplorer.Application") ie.Visible = True ie.Navigate strUrl While (ie.Busy Or ie.READYSTATE <> 4): DoEvents: Wend mmnt = Timer: While Timer - mmnt < 2: DoEvents: Wend '<= "slow downer" ie.Document.getElementById("_id0:logon:USERNAME").Value = usrnme ie.Document.getElementById("_id0:logon:PASSWORD").Value = psswrd mmnt = Timer: While Timer - mmnt < 1: DoEvents: Wend '<= "slow downer" ie.Document.getElementById("com.sun.faces.VIEW").Click '<= ? mmnt = Timer: While Timer - mmnt < 2: DoEvents: Wend '<= "slow downer" End Sub
Hi porucha,
Good Day!
Thanks for the reply, I tried your code but it gave me run-time error '-2147023179(800706b5) automation error. The interface is unknown
on this line
ie.document.getElementById("_id0:logon:USERNAME").Value = usrnme
do you think it has something to do with frames? but i dont have any idea how to code that.
Last edited by carlocruz; 01-17-2020 at 05:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks