Changing vba coding to outlook.

Hi I found some code online that automatically updates outlook with appointments in excel. However for some reason it doesn't recognize the following:

.

Please Login or Register  to view this content.

if I deleted those parts it updates the calendar but obviously I'd like to be able to add them back in.

The other issue it works fine on my main calendar but if I change the name of the calendar to another calendar i've created it doesn't do anything. No errors just never sends it to outlook.

Thanks

Tested and works fine on my end.

It actually added appointment to each of my calendars (I have 3 set up in Outlook).

How strange, thanks for trying. Is it anything to do with the fact I have excel 2007 and outlook 2010?

Excel version has little relevance here. I'd guess if it is version issue, then it's Outlook version.

I tested on Outlook 2016. So, code may need modification for Outlook 2010.

May be try the code found in link and adopt it to your need. (Note that code in link requires reference to Microsoft Outlook Object Library as is. You could rewrite it to late bind with CreateObject()).
https://blogs.msdn.microsoft.com/bru...ok-from-excel/

Hi thanks, really don’t have a great deal of knowledge with Vba how would I change it to late bind with create object?

Hi so I got pretty far with this I can now add the data to my calendar however I have access to 2 mail boxes at work and I can't change the default Name of the calendar to anything but calendar. If I leave the excel sheet with "Calendar" it send's it to
both calender's in each mail box. Any ideas how to distinguish between the two.

ummm yea so I'm guna say I've only got so far with pure luck . SO most of what you're saying is going way over my head

My code so far is:

Please Login or Register  to view this content.

So in your code, you have If olCal.Name = strCalendar Then ... This is where you check that Outlook.Folder object is Calendar folder.

If you'd want to first delete "ALL" appointments in it, prior to adding appointments via code...
Add the code I posted in #10 just below that line.

Perfect thank you!!!

You are welcome and thanks for the rep

If this solved your question, please mark the thread as solved by using Thread tool found at the top of your initial post.