Create appointments in Non Default Calendar

Hi everyone,

My first post so please excuse any foux pas!

I am trying to create a macro that creates an appointment in an Outlook calendar that isn't the default. Everything I've tried so fare either stops the macro working entirely (but doesn't give any errors) or just continues sending the appointments to the default calendar.

The appointments need to go to a calendar called "Key Dates" the path for which is \\Personal Folder\Calendar

I'm creating this using Outlook/Excel 2010 but need it to work for 2007 as well.

Would appreciate any help you can give me on this.

The Macro as of now:

Please Login or Register  to view this content.

I've made changes to the macro but this causes it to do nothing at all and it gives no errors either. ???

Please Login or Register  to view this content.

Hi John,

I still don't have this resoled and would really appreciate any help you can offer!

Adam

Thanks snb,

I've got the the appointment going to the right calendar now with the code below:

Please Login or Register  to view this content.

But I can't get this to work with a check to see if the appointment already exists?

When I was adding the appointment to my default calendar the check worked fine but now I've changed the folder path the macro stops working altogether?

Please Login or Register  to view this content.

John, thank you very much that works perfectly!

@snb that's how I remember being told to do it a school, bad teacher perhaps. Apologies if you felt I was ignoring your help, wasn't the case at all.

Hey Guys,
I am sorry I don't know if this thread is closed or not but I am new to this forum. I used that code but unfortunately excel keeps saying that there is something wrong with this line

Please Login or Register  to view this content.

. It keeps saying error. As you can see in the picture Attachment 395540. I really need this code to not repeat the appointment. However, the calendar and everything works when I remove it but it keep repeating the appointments. I don't want it to do that

Please Login or Register  to view this content.