Hi,
This will either be a very easy, 5-line answer, or a more difficult several line answer. I'm hoping for the first, but it may not exist. :)
OS: Vista Home Premium
Office 2007 (no Exchange)
The quick description: I've got a csv file with 6 fields: 'Start Date', 'End Date', 'Start Time', 'End Time', 'Subject' and 'Description'. I'd like to programatically import this into an Outlook Calendar called OMC_Diary. I can do it manually with File -> Import/Export -> From program/file -> CSV Windows -> Tell it the file, force duplicates to be overwritten, hit ok, job done. I need the code to do this automatically, which I can then run from the desktop. (Like the Access command '/x macroname')
The longer description: This csv is created from a large excel sheet using a macro to filter the rows, copy to new sheet and save as csv. (The same macro also exports another csv with different colums which my website uses). I'd then like to import the csv to the Outlook Calendar, which is published to an ical server for our users to subscribe to. Currently I manually update the website csv then upload it to the website, where a php script does it's best to generate an ical-compatible .ics file for people to subscribe to. (not using outlook, due to lack of ical support prior to 2007).
I know it can probably be done using Office automation from the original excel macro, but I'd like to keep it seperate, in Outlook, as this routine will also need to be run whenever I update the outlook calendar manually.
Can anyone help? I'm open to alternative suggestions if absolutely necessary, but being a relative beginner I'd like to keep to simple code which I can understand and then develop further.
Thanks.
Peter.
Start Free Trial
