Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Help With The Internet !!!


Message #1 by "Rob" <RobchoMan@a...> on Sat, 30 Jun 2001 14:18:24
Ok. I'm so happy right now. I have written a successfull application that 
extracts data from a web page and imports the data into my Access 2000 
database. While this is nice and saves a bunch of data entry, I can't help 
but try to make it even better !!!

When I goto to this web page, there is one text box on the page but the 
cursor does not default to it. I have to click in the text box and type in 
my value and either press enter or click on a "Submit" command button on 
the web page which in turn brings up another web page with all the data 
that I want to extract.

I save each web page in a folder, then, I run my program which reads each 
web page and extracts the data.

I can't help but think, "Is there a way I can write a Macro that will 
enter my info into the text box, simulate pressing enter, after the next 
web page is fully loaded "Meaning I have the word Done on my status bar", 
read the web page and extract the data without having to save the web page 
first. If this is possible, I would have a totally hands free way of 
extracting ALL OF THE DATA my database so desperatly needs for analysis.

A few things. I do not have to remove any HTML tags (My Program Knows 
Where All Of Them Are). Also, I can have the program return a recordset 
with all the information I am searching for. I already have the names I'm 
searching for so after I return the recordset, I can have it loop through 
the recordset so it gets each web page I'm looking for.

If anybody has a procedure for something like this, letting me know what 
it is will make my life PERFECT !!!

Thanks !!!

Rob

  Return to Index