Excel and the Internet

Creating Hyperlinks Using VBA ■ Creating and Publishing HTML Files Using VBA ■ Web Server — Storing and Opening Workbooks ■ Web Queries ■ Creating and Running Web Queries with VBA ■ Web Queries with Parameters ■ Dynamic Web Queries ■ Refreshing Data ■ Excel and Active Server Pages ■ Creating an ASP Script ■ Installing Internet Information Services (IIS) or Personal Web Server ■ Creating a Virtual Directory ■ Running Your First ASP Script ■ Generating a Tab-delimited File on the Web Server ■ Creating an Excel File from User Input ■ Printing Excel Data to an Internet Browser using the GetString Method ■ Creating Charts in ASP ■ What's Next...

The dramatic growth of the Internet that we've been witnessing over the past several years makes it possible to gain access to enormous knowledge archives scattered all over the world. Thanks to the Internet, we now have at our fingertips databases covering various industries and fields of knowledge, dictionaries and encyclopedias, stock quotes, maps, weather forecasts, and a great deal of other types of information stored on millions of existing web servers. Often, the information retrieved from web pages becomes a subject of further analysis by computer programs. Thanks to its structure (rows and columns), Microsoft Excel 2002 is a preferred tool for working with table data found on the Internet. Using Excel, you can easily create, publish, review, and analyze data.

This chapter demonstrates the built-in tools available in Excel 2002 for retrieving data from the web and publishing Excel spreadsheets on the web. You will find many Visual Basic statements here that will allow you to obtain and publish data using custom-written Visual Basic procedures. To maximize your benefit from this chapter, you should have a connection to the Internet (a modem, telephone line, or cable, an account with an Internet service provider, and an Internet browser such as Microsoft Internet Explorer 5.0 or higher).

0 0

Post a comment