Hi all,

I am importing/exporting calendar data between my Outlook calendar and an Excel (.csv) file. I would like to automate this process with macros, ideally run from Excel.

The importing/exporting function is in Outlook. When I record a macro in Excel, it stops recording when I switch to Outlook. Outlook has macro functionality but no record option.

Can anyone offer a suggestion or provide code that will enable this?

Export Process
File > Import/Export
Choose an action to perform: Export to file
Create a file of type: Comma Separated Values (Windows)
Select folder to export from: Calendar
Save exported file as: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
Replace Existing file?: Yes
Finish
Set Date Range 1/2/2008 and 30/12/2010

Import Process
File > Import/Export
Choose an action to perform: Import from another program or file
Select file type to import from: Comma Separated Values (Windows)
File to import: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
Options: Replace duplicates with items imported
Select destination folder: Calendar

The automation is complicated by the need to save and close the excel file prior to importing or exporting to/from it.

Happy to elaborate further if required.

Thank you in advance for any assistance.

Regards,

Heski