The OutlookCalendarSync Version 1.1

Overview

OutlookCalendarSync is a Microsoft Outlook VBA macro which can be used to transfer Outlook calendar data into an HP50G calculator. There is an excellent PIM program for the HP50G called “Organizer”. To import data into this program it must be in the form of a “list” with a particular structure. The macro takes Outlook calendar data and generates a text file which can be transferred to the HP50G and imported into Organizer.

 

Requirements

Installation Instructions

  1. Open Microsoft Outook 2003
  2. From Tool Menu Select Macros->Visual Basic Editor
  3. From Editor File Menu Select Import
  4. Use file open dialog to navigate to the file CalendarSync.bas distributed with this package.
  5. Use the same technique to import the file frmCalendarSync.bas.
  6. From Editor File Menu Select Save
  7. Exit Visual Basic Editor

 

Usage Instructions

  1. Launch Outlook
  2. Do whatever is necessary to make outlook display your calendar. (The macro uses the “current folder”. If the current folder is a mail or contacts folder the macro will not work correctly.)
  3. From the Tools menu select Macros->Macros
  4. In Macros dialog select CalendarSyncDialog and click Run
  5. A dialog box comes up. Use this to select an appropriate location for the output file. The dialog also allows you to specify the number of months to output. (To keep the output file size small the program outputs only the specified number of months worth of appointments.)
  6. Transfer the output file to your calculator using either USB or an SD card.
  7. On the HP50G use the filer to navigate to output file.
  8. Press the RCL softkey to transfer the file contents to the stack
  9. Exit the filer
  10. There should now be a large string object on the stack.  Convert this string to a list object using the OBJ-> function. This function is located on the TYPE submenu of the PRG menu. Use the key sequence <Left-Shift> PRG to bring up this menu.
  11. Use the organizer DAT-> softkey to load the appointments into the program. Warning: This will overwrite the organizer appointments database. Existing organizer appointments stored in the calculator will be lost.

Revision History

Version

Date

Description

1.1

3/13/07

·        There is now a dialog box for specifying output path and number of months

·        The macro now uses the current folder rather than the default folder. This allows users with multiple calendar folders to specify the desired calendar folder.

1.0

3./3/07

·        Early version which was released to early and should not be used.