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