DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Apr 27 12:58:37 CDT 2005
Sure, my example could work both ways. It's actually pretty easy. To pull data off, you have two options, though. Option 1 is to pull it from a browser. This is handy if the data is already segmented out the way you want. To pull it from a browser, just create a browser object, and navigate to the site you want data from. Then loop through the browser's document object, to grab the data within the document's objects. That's pretty easy. Just open the source of the page, and use the various control names to get the values. Option 2 is faster, and easier to code, but a little more difficult to 'sort out' the data. You can use API calls to directly download the web page, then with a little string manipulation, you can pull the data out. Drew -----Original Message----- From: Perry Harold [mailto:pharold at proftesting.com] Sent: Wednesday, April 27, 2005 11:51 AM To: dba-vb at databaseadvisors.com Subject: RE: [dba-VB] Pushing data to a web page Drew Do you perhaps have a sample of going the other way - Retrieving from a web page? I regularly access a site to retrieve data for one of my databases. Go to main page - select by an id number and then clip some of the data. Would like to automate if possible. Perry Harold -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Tuesday, April 26, 2005 10:36 AM To: dba-vb at databaseadvisors.com Subject: RE: [dba-VB] Pushing data to a web page Just sent you an example offlist. Drew -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, April 26, 2005 9:11 AM To: 'Access Developers discussion and problem solving'; VBA Subject: [dba-VB] Pushing data to a web page Does anyone know how to manipulate a web page from VB/VB.net? I need to place values in text boxes, click radio buttons, click command buttons etc. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com