+ Reply to Thread
Results 1 to 2 of 2

VBA Web Form Scraping - Blank field

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    62

    Question VBA Web Form Scraping - Blank field

    Hi everyone,

    I'm using VBA to populate a web form and 99% of it is working just fine.
    I have one problem, though, when trying to populate a field that depends on a previous one. This is an internal (corporate) web form so I can't use a real example, but here is an exercise:

    Imagine I want to populate two fields: one being the "Month" and the other being the "day". No matter the data I enter in the Month and although returning no error, the day field is always left blank.
    I'm afraid this is somehow related to some kind of validation (as you know, a standard use of the form would't allow me to select February and then have have the day 31st available...). I even tried thing like sending a tabkey between both, just in case, but it still wont work.

    Here's the code I'm using (fictional web site address):

    Please Login or Register  to view this content.
    Anyone have an idea about this?
    Thank you in advance!

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA Web Form Scraping - Blank field

    Without seeing the website, it’s nigh on impossible to help. I would take a punt and say you need to trigger the change event of the select element. There are plenty of examples online, but without seeing the html (and probably the accompanying javascript) it’s impossible to be sure

+ 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: 3
    Last Post: 08-22-2018, 06:42 PM
  2. Replies: 6
    Last Post: 06-02-2014, 04:47 PM
  3. Drop-down Form Field launching another form
    By aCmE in forum Word Formatting & General
    Replies: 0
    Last Post: 12-23-2010, 08:56 AM
  4. Ignoring a blank field in form
    By JoYang in forum Excel General
    Replies: 1
    Last Post: 08-27-2010, 09:04 PM
  5. [SOLVED] Mailmerge blank form field
    By JackieW in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 12:28 PM
  6. Copy form field value to another form (calendar)
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2005, 06:00 PM
  7. Replies: 2
    Last Post: 09-30-2005, 04:05 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