+ Reply to Thread
Results 1 to 3 of 3

VBA web crawling sap BI4 web page

  1. #1
    Registered User
    Join Date
    01-15-2020
    Location
    ph
    MS-Off Ver
    2013
    Posts
    2

    Post VBA web crawling sap BI4 web page

    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.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,150

    Re: VBA web crawling sap BI4 web page

    Welcome to the forum,

    Did you try according to this scheme ?
    What was happening, what were the (error) messages ?
    Please Login or Register  to view this content.
    But "section" '<div class="logonButton">' has not been expanded and cannot see what is there, maybe the confirmation button has a different name (?).

  3. #3
    Registered User
    Join Date
    01-15-2020
    Location
    ph
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA web crawling sap BI4 web page

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-22-2019, 07:07 AM
  2. Web Crawling on websites with no API and that requires user authentication
    By Roshan.Shakya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2019, 09:05 AM
  3. [SOLVED] Web Crawling by VBA code
    By Roshan.Shakya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-18-2019, 02:42 PM
  4. [SOLVED] Crawling list of web pages for specific value(s) on page
    By an_otter in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-17-2015, 01:45 AM
  5. Replies: 2
    Last Post: 08-07-2015, 09:01 AM
  6. QBR Crawling Inbox into Zipped File
    By jocelyn.gillespie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 10:46 AM
  7. We're crawling through mud today
    By jaslake in forum The Water Cooler
    Replies: 38
    Last Post: 08-22-2013, 11:17 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1