Writing Macros for Microsoft Excel
The macro recorder included in Microsoft Excel is a neat feature. I find it quite helpful as the recorder produces 99.9% perfect VBA code from the recorded macro keystrokes. With the computer producing VBA code, learning VBA syntax becomes a substantially easier task.
The online prompts, invoked by hitting the period character, are also very helpful as the prompts suggest the next step in building the program's "word."
I recommend working with the Microsoft Windows version of the Excel product, rather than with the Macintosh version. I have found lots of inconsistencies between the two. The most annoying inconsistency is the manner in which files in either comma separated values (.csv) or tab delimited (.txd) are saved. I experienced repeated errors as I attempted to upload a .txd file created on one of our Mac systems to a shopping cart. Once I switched over to a Microsoft Windows XP Pro System running Excel 2003, the file uploaded fine.
© Mike Blonder, 2007, All Rights Reserved