General

• Microsoft Office Training
  Online free training for Microsoft Office products by Microsoft!

• Microsoft Office Tools on the Web
• TechNet: Microsoft Office Desktop Applications
• Microsoft Office XP
  • SP2 Administrative Installation
    Update ALL from an Administrative Installation: start msiexec /i STD.MSI REINSTALL=ALL REINSTALLMODE=vomu /qb

  • Office XP Setup Commandline options
    Unattended full install (MST prepared): setup.exe TRANSFORMS=transform.mst /qb-

  • Office XP Corporate Error Reporting
  • HOW TO: Configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002
  • Word 2002 Update: Translation Services by WorldLingo
    Enable use of Worldlingo online translation service in Word 2002. No need for Word 2003, already build-in.

Office 2007

• Microsoft Official Office 2007 Learning Portal
  Free online courses and PDF e-book

• Microsoft Office 2007 Preview Site

Word 2007

• Major differences
  • The Ribbon Menu
    • Shortcut keys are backward compatible with Office 2003
  • Building Blocks
  • Instant Live Preview
  • themes, equations, and content controls
  • Install Add-in from Microsoft to allow Word save as PDF or XPS natively
  • Open and Repair function to recover corrupted file
  • Backup copy
    • Office button -> Word Options -> Always create backup copy, auto create wbk backup file
  • New file format
    • *.docx, *.dotx extension for normal document, no Macro
    • *.docm, *.dotm extension for document with Macro
    • old version need to use add-on. At www.office.microsoft.com, type: Office 2007 compatibility

Office 2003

• Office 2003 Resource Kit Downloads
• Missing SKU011.CAB when running Office Update
  Try to copy the MSOCache folder from another computer or reinstall Office 2003 again

Microsoft Outlook

• Add Microsoft Mail support to Outlook 2003/2007
• OL2002: How to Move the Hotmail .PST Cache File
  Also works for IMAP .PST cache file, and also works for Outlook 2003

• POP3 Save password setting not retained in Outlook or Outlook Express
  Remove protected storage registry and save the password again. To fix the same problem for IMAP, may need to re-create the IMAP account.

• Shutdown Addin v1.11 for Outlook

Microsoft Visio

• Microsoft Visio Homepage
• Visio Stencils
  • Avaya
  • NEC Data Networking
  • Lots of Server vendors Stencils at VisioCafe website
  • Dell
  • Cisco
  • Polycom
• Visio 2003 Software Development Kit (SDK)
• Visio 2002 Automation ‘Hello World’ example code
• Using the Save as Web Page object model from Visual Basic: an example
• Running Save as Web Page from the command line / from add-on
• Supplimentary, not related to Visio
  • PHP COM example calling Word
  • PHP: Interfacing With COM Objects Under Windows NT/2k/XP
  • COM Functions in PHP4 (Windows)

Office 2000

• 202946 – OFF2000 Setup Command-Line Switches for Office 2000

Microsoft Word

• Picture a watermark in your Word document (Word 2002, Word 2003)
• Modify watermark in Word 2002/2003
  Find them in the Header/Footer page, it is just a word art image there.

Microsoft Excel

• KB323626: “SYLK: File format is not valid" error message when you open file
• Q120596: Text files that are larger than 65,536 rows cannot be imported to Excel 97, Excel 2000, Excel 2002 and Excel 2003
  Before Excel 97: 16384 rows
  Excel 97-2003: 65536 rows
  Excel 2007/2010+: 1M rows

• 130560 – XL Commands and Features Unavailable in Shared Workbook (Excel 2000)
• A discussion on Excel’s maximum filesize
  Excel 2000: ~64M
  Excel 2002: ~128M

Excel in Statistics

• Excel For Statistical Data Analysis

Microsoft Office OneNote

Training from simple to complex, I think

• OneNote 2003 Demo
• OneNote 2003 Tour
• Microsoft Office Online – OneNote Trainings
• Office Online Assistance – OneNote (HOWTO Articles)

Other Information

• Microsoft’s OneNote 2003 FAQ
• Ben Schorr’s OneNote FAQ (unofficial)
• OneNote Tips subscription and archive
• Chris Pratley’s OneNote WebLog (from the “father" of OneNote in Microsoft)
• Download OneNote Stationery by Community Members
• Official Microsoft Newsgroup for Microsoft OneNote (for asking questions)

Microsoft PowerPoint

• How to convert PowerPoint Slides to a movie
  1. Show the PowerPoint to the machine’s Video Out (usually a notebook?), record it with a DVD Recorder or a VCR!
  2. Use Screen capture program the capture the whole presentation.
  3. Save each PowerPoint slide into a picture, import into movie making program.

• PowerPoint Design Templates
  • Worldwide Design Template
• Powerpoint Art by Dolphin Ink

Microsoft Outlook

• Microsoft Outlook
• Attachment Options COM-Addin (Allow open blocked attachments)
• Slipstick Microsoft Outlook and Exchange Info
• Copy Outlook contacts to the Outlook Express address book
  For Outlook 2002 and 2003

• Mapping Outlook Contacts
• Recover empty deleted e-mails in Outlook PST file
  Use a HEX editor to set position 0x07 to 0x13 to “0x20″ (space), then fix with scanpst tool and open in Outlook again. If successful the recovered e-mail should be in the Deleted Items folder.

Microsoft Access

• Check null value in Access SQL
  …WHERE fieldname is null…

Groove 2007 (SharePoint Workspace)

• Groove 2007
• Wikipedia: Microsoft Groove
  • Offline file & collaboration function
• TechNet: Microsoft Office Groove Server 2007

Live Communications Server

• Live Communications Server 2003
• How to Upgrade Live Communications Server 2003 Evaluation Edition to the Released Version
• Live Communications Server 2003 documentations download
• Discuss on solution to problem: Error 27619: Error ‘0x80072030’ adding the property page during “CreateEnterpriseObjects".
  (This solution is incomplete!)
  Maybe has problem when Exchange Server is in the same machine?
  Solution: Use ADSIEdit, manual add object (class: displaySpecifier) cn=organizationalUnit-Display, cn=413, cn=DisplaySpecifier, cn=Configuration, cn=yourdomain, cn=yourTLD
  Manual run rtcsrv.msi prep=enterprise
  Then run the Home Server install again

• Windows Messenger 5.0
  For Live Communication Server connection

• Course Download: Deploying Microsoft Office Live Communication Server

Microsoft Office InfoPath

• InfoPath Developer Trainings
• Office Developer Center: InfoPath
• InfoPathDev.com
  Contain some custom InfoPath scripts, such as allow re-order repeating table rows

Development

• MSDN Office Developer Center

3rd Party

• Woody’s Office 2003
• Mail Merge ToolKit
  Good e-Mail Merge add-on, allow customize subject and has attachments

• Password Cracking FAQ
  Because of US export regulations Office 97 uses 40-bit key. So encrypted files can be decrypted without password knowledge in a few days by searching for this key.
  By default Office XP/2003 use Office 97-2000 compatible mode.

• A Word Password Recovery software that may work