Zach Frey's Office Software Resources

Notes on Microsoft Office(tm) and other office suite software.

This is mostly a way to organize my bookmarks right now. Maybe someday I'll actually have some content here.

Microsoft Office Resources:

• Excel VBA examples
• VBA Pro
• The MSDN Microsoft Office 2000/Visual Basic Programmer's guide
• Training Resources for Microsoft Office Developers
• The Duwamish Diary team bios (hi Paul!)
• Accessing Microsoft Exchange and Outlook Data Using Visual Basic
• Devout is a VBA utility to export Outlook 2000 email to Evolution mbox format.
• Excel to Access: a tutorial on converting Excel spreadsheet applications to Access database applications.

Useful Microsoft Knowledge Base Articles

• Not sharing your secrets with the whole world:
  • OFF: How to Minimize Metadata in Microsoft Office Documents. This contains pointers to specific KB articles for each Office application.
  • HOW TO: Minimize Metadata in Microsoft Word 2000 Documents
  • WD97: How to Minimize Metadata in Microsoft Word Documents
  The basic summary: Turn "Fast Saves" off. Then save your document. This is supposed to purge old document fragments.
• WD2002: How to Track and Manage Changes in a Word Document