Macintosh Excel MVP Page
By Jim Gordon, Mac MVP

Articles about working with external data:

Macintosh, Microsoft Office 2004, and Microsoft Access (This will download a Microsoft Word document.)

Microsoft Office For Macintosh Database Connectivity Overview

Using Microsoft Office as a Relational Database

How to link Excel data with a graph in Word or PowerPoint

How to create Web query files for use with Excel for Mac

How to Programmatically Perform a Web Query using Visual Basic for Applications (should be good for all Excel versions through 2004)

You can not edit a web query by clicking on the "edit query" button on the data tool bar

Use Excel Macros (Visual Basic for Applications

How to shade every other row (PowerPoint presentation)

Capture Report

A free Excel template that imports table data from web pages into Excel.

Enter any URL and this will grab its table information and put it into a new workbook. This workbook contains macros that are safe to enable. The workbook uses a web query to bring table data into Excel and then formats it so it looks nice.

Click here to download Capture Report for Excel 2001 (Free Excel Template)

For Excel versions X (without 1.0.1.5 update), XP and 2004 click here.

Dealing With Trouble Articles:

Summary of Methods to Recover Data from Corrupted Excel Files

Using Older Versions of Excel

Excel version 5 does not run in OS9.
Excel 2001 in OS 9: With extensions turned off, run the OS9 update available from the Office web site.

Older versions of Excel such as Excel 98, and Excel 4 may run in OS 9 and Classic in OSX. There's no guarantee of a smooth ride.

 

Excel MVP Links

J.E. McGimpsey's Excel Pages
Jon Peltier's Excel Page
http://www.tushar-mehta.com/
Chip Pearson's Excel Page


Jim's Mac MVP Home