+ Reply to Thread
Results 1 to 3 of 3

Controlling Internet Explorer no textbox and button ID in source code

  1. #1
    Registered User
    Join Date
    12-08-2016
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    2

    Controlling Internet Explorer no textbox and button ID in source code

    Dear all,

    I've been trying to control the internet explorer in order to automate some workload but for some reason I am not able to spot the textbox and button ID in the html source code.
    If I use the developer tool I can see all the button/textbox id, names etc. listed on the DOM browser but I am not able to connect excel vba with those id's because the source code on the main site does not contain the ids.


    How do I get excel vba to control that site without being able to spot those textbox and button id within the source code?

    In the past I used these script to control the internet explorer but on that site it doesn't work:

    Please Login or Register  to view this content.
    I've included the source code of that site as attachement and also the source code from the DOM explorer that is not visible on the main site source code.
    Any help is hightly appreciated
    Attached Files Attached Files
    Last edited by Leith Ross; 12-08-2016 at 05:59 PM. Reason: Added Code Tags

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Controlling Internet Explorer no textbox and button ID in source code

    If you debug using Firefox & FireBug or equivalent using another browser. You should be able to trace what requests are sent to web site (either GET or POST) method along with parameter string. It's usually far faster than controlling IE and more reliable.

    Below is example of how MSXML2.ServerXMLHTTP is used to send "GET" request and reading specific table from response.
    Please Login or Register  to view this content.
    Done in two step (to get appropriate URL string from phone#).

  3. #3
    Registered User
    Join Date
    12-08-2016
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    2

    Re: Controlling Internet Explorer no textbox and button ID in source code

    Hi CK 76,

    thanks for drawing my attention to the MSXML2.ServerXMLHTTP solution.
    The issue with the site above was that there was some java scripts that hides the source code and links from displaying but al the source code and textbox id was there.
    I have been able to automate the download and the manual work in the mean time.
    The only issue that I have now is to wait until the site is loaded after clicking on a button since the syntax loop until ie.isready does not work on a java script site.
    Thanks again for your help.
    Last edited by Cecilia2011; 01-08-2017 at 05:13 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. Help clicking a button on internet explorer via VBA
    By ExcelJWS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2016, 09:05 PM
  2. Click Button in Internet Explorer using VBA
    By bishop-jese-erl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2015, 12:39 AM
  3. Clicking a button in Internet Explorer
    By Matty5894 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2015, 06:19 AM
  4. [SOLVED] Clicking a button in Internet Explorer
    By Matty5894 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-03-2015, 09:02 AM
  5. [SOLVED] VBA Internet Explorer - Select Button *** HELP ***
    By vbafreddie in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 12-12-2014, 11:11 AM
  6. VBA Internet Explorer Source File Redirect
    By vbaguy33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 04:36 PM
  7. Controlling Internet Explorer
    By akronpow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2007, 09:11 PM

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