Excel/Outlook VBA

[JIC41]

I want to write a macro which takes a schedule from an excel spreadsheet and puts it into Outlook.
It would basically go through cell by cell, find the date of the appointment and put it in the appropriate day in an outlook calender.
I am an experienced programmer, so I dont need help with the algorithm, I just need to know how to actually write a macro which will use both programs. I have never worked with VBA in outlook.
Any help would be appreciate, or if you could give me the name of a book or website that would have what im looking for.

thanks a lot.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/vbaol11/html/OutlookVBAWelcome_HV01136199.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

Check out

http://msdn.microsoft.com/library/d...dcore/html/deovrunderstandingvbainoutlook.asp

http://www.microsoft.com/downloads/...80-23E2-456F-8618-4DA50CC2C38C&displaylang=en

Particularly, set a reference to the Ms Outlook Object Library and chack out CreateObject method

Skip,

_[red][/red]