Question about VBA references - Microsoft Outlook library

Hi Guys,

i have a program that creates a calendar entry at the end of the macro. I wrote this vba in excel 2013 so the reference in the VBA tools is Microsoft Outlook 15.0 object library. however i now have a problem. all the rest of my team that is using this program is using excel 2010. which uses microsoft outlook 14.0 object library.

how do i set the reference to be 14.0?

should i open the code with excel 2010, add the 14.0 library reference, save and then will it automatically upgrade to 15.0 for my 2013 excel?

thanks in advance

You should have access to the older libraries. If you want highest compatibility you want to use the oldest library since that will cover more versions. Just be mindful that you may have to change the syntax since it may be different depending on the version.

i have looked through the references and the ONLY outlook refreence is 15.0

ok heres a question - the file gets saved on a server drive and is updated sporadically - if i were to have the file that is updated always have the outlook 14.0 object library ticked in teh references (through using excel2010 to save the VBA code) will it when opened on my computer, update itself to 15.0 automatically?

References don't update on their own.

Try using late binding to create your outlook. http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

Please Login or Register  to view this content.

thanks Six -
so if this is the code....

Please Login or Register  to view this content.

error - variable not defined - highlights sub addtooutlook() in yellow

and takes the cursor to and highlights

Please Login or Register  to view this content.

instead, use

Please Login or Register  to view this content.

sorry i am struggling with the early to late binding - and now i have two answers....im a little confused. i copied yours over six and now the error is object variable with block variable not set and highlights

Please Login or Register  to view this content.

thanks norie - but i do not know where to go with the next error that came up after changing to Six's suggestion. sorry to be such a noob here

ahh yes i am stupid - had nothing populated. however the last variable that needs to be amde constant is

Please Login or Register  to view this content.

ok then maybe this is my newness coming thorugh. here is the full code right now - the bold line is what is eoming up with an error:"object variable or with block variable not set"

Please Login or Register  to view this content.

fantastic - thanks to you both for your help!!!