Chris,
The issue here is that, although the page is simple and it's easy to perform
a search once or twice, the job requires performing a search for each of
many items.
Thus, if they were doing this manually, the user would have to search for an
item, grab the data, enter it into a spreadsheet, and then go through the
cycle again many times. I was hoping to automate this process by having a
visual Basic code which would grab the list of items to be searched for from
a data file, and then automatically perform the search and retrieve the data
for each item in the original data file.
I have to believe that this is possible using Visual Basic, but can't quite
figure out how to use the HTMLDocuments or HTMLElements objects in Visual
Basic to identify and click on the proper web links.
-- Pete
Date: Sat, 11 Oct 2008 19:10:24 +0800
From: Chris Legg <[EMAIL PROTECTED]>
Subject: Re: [Blind-Computing] Navigating a Web Site Using Visual
Basic
To: [email protected]
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
How would filling the information into an application differ from
entering it into the site itself? The form looks fairly simple.
Peter Torpey wrote:
> Just to be more clear, I need to automate this search procedure for a
friend
> who has to perform many, many searches from this web site.
>
> I know how to retrieve the data once the search has been performed, but I
> don't know how to find the search box, enter the search query, and submit
> the form using Visual Basic (since this has to be done lots of times).
>
> Sorry if this was confusing.
>
> -- Pete
> E-mail: [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Peter Torpey [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2008 3:29 PM
> To: '[email protected]'
> Subject: Navigating a Web Site Using Visual Basic
>
> I am trying to write a Visual Basic program to automate a procedure for a
> friend. I need some advice or a reference on the HTML Document Object and
> how to use it for this purpose.
>
> Here is the procedure:
>
> 1. The user needs to go to the web site:
> http://www.co.wayne.ny.us/RPT-TaxSearch/
> 2. The user needs to click on the "I Agree" button at the bottom of the
> page.
> 3. This brings up a new web site with a search box.
> 4. The user then needs to enter and ID# in the search box and perform
> the search.
> 5. The results come up with a table from which the user needs to get
> some info and put it into an Excel document. This part I can do if I can
> get over doing the first few steps of getting to this page and performing
> the search.
>
> Anyway, here is some of the code I am using:
>
> Sub AcquireData(ByVal browser As WebBrowser) ' the parameter browser has
> already been set up to connect to the URL which contains the "I Agree"
> button
>
> ' set up the document object for the web page
> Dim doc As System.Windows.Forms.HtmlDocument ' use the HTMLElement
object
> if necessary
> Dim Element As System.Windows.Forms.HtmlElement
>
> doc = browser.Document
> ' now, here is where I need the help:
> ' 1. Find the "I Agree" button on the page
> ' click on the "I Agree" button to bring up the search page ' find the
> search field for the ID# on the new page ' enter the search ID# (which my
> application acquires in another subroutine)
> ' Once the new page comes up, I have the code to process the table on
> the page and deal with the data
> Call ProcessTable( browser )
>
> End sub
>
> Thanks for any help, suggestions, or references. Since this is rather a
> specialized topic, you can reply to me off list at:
> [EMAIL PROTECTED]
>
> -- Pete
>
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[EMAIL PROTECTED]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[EMAIL PROTECTED]
Use the following address in order to contact the management team
[EMAIL PROTECTED]
If you wish to join the JAWS Users List send a blank email to the
following address:
[EMAIL PROTECTED]
