+ Reply to Thread
Results 1 to 5 of 5

input type "hidden" onclick "document.text.submit ...for web login and parsing

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    input type "hidden" onclick "document.text.submit ...for web login and parsing

    Sorry had to take out some chrs to post...This is what the subject should be: <input type="hidden" & onclick="document.text.submit() ...for web login and parsing

    Hi,
    The below code is in a command button (building a web parser for secured site personal use).
    If the button is pressed once then the code makes it pass the login page but gets stuck at the "Launch The Page" value.
    If the button is pressed a second time, then it appears the launch page is clicked and then the "hidden" page click fires.

    How to handle this please?



    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: input type "hidden" onclick "document.text.submit ...for web login and parsin

    I'm a bit confused, as far as I can see the button you are clicking isn't hidden.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: input type "hidden" onclick "document.text.submit ...for web login and parsin

    Thanks Norie.

    The CommandButton1 is on a userform in excel. That runs code that opens IE up to but does not click the Launch page.

    If I hover mouse over the web-page-button it shows http://somewebsite.com/account/login/mac_open.php

    Now mousing back and clicking on CommandButton1 again it then appears to click the Launch page AND opens a another page.
    (I can not tell what this page is called (or don't know where to look) when looking in the DOM Explorer (inspect element)).

    A few seconds later the final page loads. It's from this page I will yet click again and then go to parsing.



    Sorry it's a secure subscription site so giving the real url does not help.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: input type "hidden" onclick "document.text.submit ...for web login and parsin

    I wasn't referring to the button on the userform, I was referring to the input elements on the page.

    In your thread title you mention that 'hidden' but in the posted code the input element you are clicking isn't hidden.

    I'm also not sure what the actual problem is.

    Does the code you posted not do what you want it to?

  5. #5
    Registered User
    Join Date
    05-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: input type "hidden" onclick "document.text.submit ...for web login and parsin

    ah, sorry.

    Does the code you posted not do what you want it to?
    Good question Norie! Should have asked that myself!

    Yes and no.
    Yes if I click the CommandButton1 twice, ultimately it does open the next page I need to get to. There is one more page to get to before I can begin parsing.

    No in the sense that "why does it not click the page in one click?" that's what the code says it should do.


    Ok considered this resolved, from my perspective, based on this:

    (1) It's the nature of the CommandButton1 to have this characteristic.
    (2) I entered the code into a Module, click Run in the editor and it runs all the way through the code and clicks the "Launch Page".

    Just starting this scraping project so I may be back with other questions and will post accordingly! (after searching)

+ 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. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  2. Excel 2007 : "Inspect Document" misses hidden rows
    By beng404 in forum Excel General
    Replies: 1
    Last Post: 06-26-2012, 02:50 PM
  3. Proper handling of "cancel" for range-type input box response (type 8)
    By MCCCLXXXV in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-28-2011, 11:19 AM
  4. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  5. Replies: 4
    Last Post: 02-03-2008, 05: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