Prior to Lync 2013, there was a reference you could use for connecting Lync/Communicator to VBA:
Microsoft Office Communicator 2007 API Type Library
This allowed you to write code such as:
Dim msgr As CommunicatorAPI.Messenger
Dim msg As CommunicatorAPI.IMessengerConversationWndAdvanced
You could then write code to manipulate Lync such as generating IMs, etc.
I have recently "updated" Office to 2013. However, all code such as the above no longer works and it appears the required dll is not included in the Lync 2013 installation. VBA complains as the reference is not found.
Downloading the Communicator 2007 SDK does not allow me to load the reference. I suspect I could rewrite all that code to treat this as a standard dll (maybe?).
What file do I need to reference with Lync 2013?
I did award a bounty to this question - but have since read 2 posts on MSDN Social that suggest MS have stopped supporting the automation PI for Lync.
The closest thing I could find is a quote from this page
"Lync 2013/SfB 2015 does not expose COM entry points that Excel can use.
You can create a wrapper around the Lync 2013 SDK and expose some COM objects that could be used from Excel."
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With