Thanks for the help. The XMLHTTP object in the XML library does the job very nicely.
My only other question is how you can access a password-entry Web site with this method? I'll ask in the other forum if/when I need that. Many thanks for the quick help. -Tim -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of rharmelink Sent: Wednesday, March 22, 2006 12:36 AM To: [email protected] Subject: [Access VBA Central] Re: Reading Web pages with Access --- "Heaton, Timothy H. \(USD\)" <[EMAIL PROTECTED]> wrote: > > I have a need to read Web pages and download the text to extract data > with code. I'm sure this can be done with VB. Could someone point me > to a method for instructing VB to 1) open a Web site given the URL and > 2) read the source code from the page? Also, what references would be > needed to do this? Thanks for any help you can provide. Head over to the files area of the XLTrader Yahoo! Group: http://groups.yahoo.com/group/xltraders I have an add-in in the "VBA -- Stock Market Functions" folder that does a lot of that. The VBA source code is not password protected, so you can adapt it as needed. If you have any questions about the files, ask in that forum -- I don't watch this forum very closely. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
