+ Reply to Thread
Results 1 to 3 of 3

VBA Button click on HTML Object does not work

  1. #1
    Registered User
    Join Date
    05-24-2019
    Location
    Sanem, Luxembourg
    MS-Off Ver
    2007
    Posts
    6

    VBA Button click on HTML Object does not work

    Hello,

    I wrote a small vba programme, that emulates filling an internet form with data from my excel sheet. Unfortunately, when it comes to clicking the Save button, this one does not react. All other buttons (navigation, update, delete) work fine with the obj.click command, but the Save (New) button doesn't. Could it be that in HTML there is a way to prevent buttons to work when they are pseudo-clicked from any kind of programming tool? ... and, if yes, is there a way to work around that?

    Thanks for help.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA Button click on HTML Object does not work

    Hello hinmi1905,

    Sometimes a web developer will use a picture in place of button. Pictures have no events. This will be triggered by Java when the user moves the cursor onto the object and clicks.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    05-24-2019
    Location
    Sanem, Luxembourg
    MS-Off Ver
    2007
    Posts
    6

    Wink Re: VBA Button click on HTML Object does not work

    Hello Leith Ross,

    Thanks for that info ... I am not sure whether that's the case here, because it shows some kind of "::before" stuff in the HTML, same as for the other buttons, but that's definitely a good trick to remember.

    Any idea on how I could get around that nasty stuff?

+ 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. Object Required Error on Command Button Click
    By jsmilke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-26-2017, 05:00 PM
  2. Trouble parsing HTML to click javascript button
    By fhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2016, 02:58 PM
  3. Macro to work on HTML and to click on a link and save the excel exported
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2016, 10:22 AM
  4. VBA click an html button without input tags
    By klturi421 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2016, 04:33 PM
  5. Click on HTML Button
    By killerkoz17 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2014, 06:08 PM
  6. Replies: 0
    Last Post: 10-11-2012, 04:18 AM
  7. Macro Button does not work on second click
    By retseort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2005, 06:12 PM

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