If you want to work with Excel, add a reference to it via Tools/References.
Use the object browser (f2) to get familar with both models, Outlook and
In order to open a spreadsheet, use the Workbooks.Open function. Select
Workbooks in the left pane of the object browser, and the function in the
right pane, then press f1 for more help.
You can use the Range object to loop trough rows and/or columns in the
spreadsheet. The content can be read via Range.Value.
In Outlook create a new appointment by using the CreateItem function.
Am Sat, 6 Feb 2010 11:19:02 -0800 schrieb Nrotta:
> Hello Everybody
> I wonder if someone could help me.
> I would like to create an Outlook Macro to import calendar froma excel
> instead of using the tradicional Import/export wizard.
> Thanks in Advance