+ Reply to Thread
Results 1 to 2 of 2

Using Excel to Complete Form in Internet Explorer

  1. #1
    Registered User
    Join Date
    05-15-2007
    Posts
    16

    Using Excel to Complete Form in Internet Explorer

    I've peeled over numerous volumes, both online and off, attempting to figure out how to use Excel VBA to complete an HTML form in order to search for entries in a database that I do not have direct access to but for the HTML form. It contains numerous checkboxes, a text input, and a submit button. I cannot for the life of me figure out how to get the VBA to detect the checkboxes and set them to checked or unchecked. I tried the createobject technique to take control of the Internet Explorer Document Object Model to do it, but I've been confounded by the syntax, meeting with various debugging errors like the object not supported when I use set objCheckbox1 = document.forms.checkbox("C1") code so I can try to use the objCheckbox1.Click() method, among others.

    Can somebody please lead me in the right direction so I can code the VBA to control the Internet Explorer Object model? W3C seemed promising, but did not provide the needed example to allow me to figure this out. Even lacking an example, even a book that would allow me to quickly learn this code would be fine.

    Thank you in advance.

    Thank you.

  2. #2
    Registered User
    Join Date
    05-15-2007
    Posts
    16
    Got it found by way of a tip I was sent via a PM:

    Please Login or Register  to view this content.
    Now I'm off to search for a method of reading the results page, and return a count of occurrences of a specified text string back to the active cell. Does somebody know how to do that with a web page?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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