香港新浪網 MySinaBlog
Emily | 5th Aug 2007, 12:11 PM | Network / Media | (2181 Reads)

Using VBA to access the Net

 Tushar Mehta:

Over the past few years there has been an increase in people who want to programmatically access information available over the Internet.  There are a few different ways of doing so with results available in a few different formats.  In this chapter I discuss some of the methods and formats.  The methods include the use of InternetExplorer and XMLHttp and the formats include the “human friendly” HTML as well as XML and JSON.  As part of the discussion of XML, I present a XSL stylesheet to convert a webservice XML output into a SpreadsheetML form that can then be opened directly by Excel.  By the end of the chapter, the reader will know how to develop fully functional code to support concurrent asynchronous VBA access to multiple web sites.

For details please refer to

http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm