Excel Mssing Microsoft Outlook 15.0 Object Library (TABLET)

[makaveli621]

Good Afternoon All,
I have for weeks been trying and searching on how to fix this problem. I've created an excel program (in my Computer that has the new version of MS office 2013) that sends reminders to Outlook and Creates contact in outlook using Excel macros. We recently bought Asus T100A Tablets that comes pre-loaded with MS Office 2013 and it comes with Windows 8.1.

The issue i'm having is that I created this program in my computer but when my sales person tries to run this program in the tablet, everything works, every macros works EXCEPT the Outlook macros. Its says "Excel Missing Microsoft Outlook 15.0 Object Library" but I can't find the solution on how to fix this. Has anyone encounter anything like this. Can someone tell me how do I fix this so my program can send reminders and create contact and send emails to outlook? I searched the reference library in the tablets but can't find it. Please someone help me.

 

[K e v i n]

Hi,
The version of the Outlook Object library varies with the version of Office installed; for example Office 2010 has version 14.0. When you create a macro using references in a 'lower' version and copy it to a higher version of office the reference numbers are automatically updated, this is NOT the case the other way around. What version of Office is being used on the tablet? If its lower than the one the macro was created in then that's the problem. If this is the case, then on the tablet open the references in developer and you will see '15' listed as missing un-select it and scroll down to pick the correct reference for that version of Office. Hope that helps

Kev

 

[shg]

Nice explanation, Kevin.

As an alternative, you could use late binding, and the most recent library on each tablet would be loaded.

 

[K e v i n]

Hi makaveli621,

shg is of course correct - if you'd like to read up on late binding try the MS article Using early binding and late binding in Automation