Excel to shared calendar macro

[Garouken2]

Hello I am in desperate need of some help! please take a look at the following code that works for putting appointments into my own default calendar in outlook, however I require it to input to a shared calendar. I have looked all over and found the Dim outlook.folder but I keep getting compile error I know the code below isn't clean but any help would be greatly appreciated


if this helps the shared calendar is in "all public folders/workforce admin/WFD/WFD Adults"

Please Login or Register  to view this content.

[cytop]

As you seem to be using Late Binding, oFolder should be declared as an Object. 'Outlook.Folder' means nothing unless you have a references set to the Outlook Object model (Early Binding).

You will also need to define other constants (olPublicFoldersAllPublicFolders, for example) which are defined in Outlook, exactly the same as you have done for olAppointmentItem

[Garouken2]

I am really sorry but I am completely out of my depth here I cant seem to implement the changes you suggested

[cytop]

What have you tried...?

Declare oFolder as type Object
Define a constant for olPublicFoldersAllPublicFolders

You'll find the enumerations for Outlook folders here. Define a constant, same as olAppointmentItem, for olPublicFoldersAllPublicFolders using the appropriate value from that list.

If there are any other ol... variables in code you haven't posted then they need to be defined as well.

[Garouken2]

Hi this is what I have

Please Login or Register  to view this content.

[cytop]

You have an oNameSpace object which is never assigned a value - at a guess this should be OLNS rather than oNameSpace.

I didn't look at the code except for the obvious issues mentioned in your first post but the code adds an appointment to the default calendar and then gets a reference to to the folder WFD Adults... but doesn't do anything. You need to rejig the code - get the reference to the folder then add the appointment.

You might find a reply from yesterday in another thread helpful: http://www.excelforum.com/excel-prog...ml#post4588280

[Garouken2]

managed to sort it using a different way of linking to the calendar code attached for benefit of anyone else looking this up

Please Login or Register  to view this content.

Thank you for all your help and I greatly appreciate your time