Business and Technology Consulting

When is Excel not Excel?

Several years ago, I had implemented a simple timesheet in Microsoft Excel. It used VBA macros for pop-up dialog boxes to support lookup tables and an interface to QuickBooks. 

The controller like it so much that she took it with her to her next job where some of the workstations were Macs. The prior company was in a Windows-only environment. She was disappointed to find that the VBA macros did not function on the Macs.

After researching the problem in the Microsoft  Knowledge Base, we discovered that the Excel is not necessarily Excel. The Macintosh version differs from the Windows version.

So, if you design VBA macros for both Windows and Macs, make sure you find out when Excel is not Excel.

(C)Copyright 2005, James T. Moran & Associates. All rights reserved.