Whats Next

In this chapter, you were introduced to using Excel with the Internet. Let's quickly summarize the information that we've covered here:

■ Hyperlinks allow you to activate a specified web page from a worksheet cell.

Excel files can be easily viewed in an Internet browser.

■ HTML files can be created and published from Excel using menu options or VBA procedures.

■ Web queries allow you to retrieve "live" data from a web page into a worksheet. These queries can be created using built-in menu options or programmatically with VBA. Web queries let you retrieve an entire web page or specific tables that a particular web page contains. The retrieved data can be refreshed as often as required. There are two types of web queries: static and dynamic.

■ Active Server Pages (ASP) is a technology from Microsoft enabled by the Internet Information Services (IIS) or Personal Web Server. ASP allows you to create dynamic web pages. Using ASP you can retrieve information stored in external data sources (such as a Microsoft Access database or SQL Server database) into an Excel spreadsheet.

■ Using several hands-on examples, you've learned how to write and run ASP scripts, generate a tab-delimited file on the web server, create an Excel file from user input, and use the Excel Chart Wizard to create charts in ASP.

In the next chapter, you will explore another Internet technology known as

XML and find out how it is integrated with Excel.

0 0

Post a comment