Create Calendar event with late binding VBA

  • Thread starter Thread starter Randy Harris
  • Start date Start date
R

Randy Harris

I would like to be able to create an event in Outlook Calendar from VBA in
Access using late binding.

Can someone point me to sample code somewhere that would help me get
started?

Thanks for any suggestions.
 
Am Tue, 6 Sep 2005 23:36:28 -0400 schrieb Randy Harris:


I would like to be able to create an event in Outlook Calendar from VBA in
Access using late binding.

Can someone point me to sample code somewhere that would help me get
started?

Thanks for any suggestions.
Click to expand...

Late binding means that all objects are declared as Object. E.g. instead of
Dim oTask As Outlook.TaskItem
you need to write
Dim oTask As Object

I´d suggest that you add a reference on Outlook to your Access project. Then
you can use the Object Browser, it helps you finding functions, the help for
them, samples etc. E.g., you´re looking for the CreateItem function.

In the end you can remove that reference.
 
Michael Bauer said:
Am Tue, 6 Sep 2005 23:36:28 -0400 schrieb Randy Harris:




Late binding means that all objects are declared as Object. E.g. instead of
Dim oTask As Outlook.TaskItem
you need to write
Dim oTask As Object

I´d suggest that you add a reference on Outlook to your Access project. Then
you can use the Object Browser, it helps you finding functions, the help for
them, samples etc. E.g., you´re looking for the CreateItem function.

In the end you can remove that reference.
Click to expand...

I did as you suggested, set the reference, then got the code working. I was
subsequently able to change it to late binding. Thank you for the help.
 
Back
Top