excel vba SKYPE4COMLib无法与Skype for Business(SfB)一起​​使用 [英] excel vba SKYPE4COMLib is not working with Skype for Business (SfB)

问题描述

是否可以使用Excel VBA通​​过Skype for Business发送消息? 我试图添加SKYPE4COMLib和以下代码:

Is there a way to send messages via Skype for Business using excel VBA? I tried to add SKYPE4COMLib and following code:

Sub skype()
Dim aSkype As SKYPE4COMLib.skype
Set aSkype = New SKYPE4COMLib.skype
Dim oChat As Chat
Dim skUser As SKYPE4COMLib.user
    Set skUser = aSkype.user("user_name")
    Set oChat = aSkype.CreateChatWith(skUser.Handle)
   oChat.OpenWindow
   oChat.SendMessage "automated message"
End Sub

但是它不起作用:( 可能吗? 非常感谢你！

But it is not working :( Is it even possible? Thank you very much!

推荐答案

请注意，有两种产品:

• Skype for Business(SfB)[以前称为Lync]
• Skype for Consumer(SfC)

• Skype for Business (SfB) [former known as Lync]
• Skype for Consumer (SfC)

这两种产品均可用于聊天和通话(VOIP)，但它们不是是相同的产品. SfB主要用于那些SfC主要用于消费者的公司，您可以在此处免费下载客户端，也可以免费使用SfC的某些功能.

both products can be used for chat & calls (VOIP) however they are not the same products. SfB is mostly used for companies where SfC is mostly used for consumer as you can download the client here for free and can as well use some features from SfC for free.

Skype4com.lib仅与SfC兼容，而不与SfB兼容.这是由于Lync 2013/SfB 2015不公开Excel可以使用的COM入口点的原因(请参阅 UCWA 2.0 .

The Skype4com.lib is only compatible with SfC and not with SfB. This is due to the reason that Lync 2013/SfB 2015 does not expose COM entry points that Excel can use (see here). If you wish to send chats with SfB you should check UCWA 2.0.

这篇关于excel vba SKYPE4COMLib无法与Skype for Business(SfB)一起​​使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！