Create Outlook event/appt in non-default calendar folder

[Finny388]

Boy this kind of info is scarce.

I just want a routine that will create events in Outlook based on cell
contents.

I can't find how to reference a specific/non-default calendar folder,
let alone do this at all.

Help?

Thanks

 

[Guest]

Have you tried asking in the Outlook newsgroup for assistance in doing this
in outlook. Once that's together, we probably can help get it to run out of
Excel.

 

[Guest]

Hi

The following code from www.excelkb.com gives some clues
This is not for the calender but for the journal items

Dim olApp As Outlook.Application

Dim olNamespace As Outlook.Namespace

Dim olJourFolder As Outlook.MAPIFolder

Dim olJourItem As Outlook.JournalItem

From the above after setting reference to the Outlook object model
You should have access to all objects within the Object browser - search for
calender

HTH