Hi Dan,
If you want to start a Messenger chat from within the Excel, you need to
write some VBA code.
First you need to add a reference to the Messenger API from your Excel VBA
project.
1. Open the Microsoft Visual Basic IDE in Excel (Alt + F11).
2. From the Main menu, choose Tools - References
3. In the References - VBAProject dialog, check the "Messenger API Type
Library" (You'll need Messenger installed to get this).
4. Click OK to close the dialog.
5. Add the a new Module to your VBA project.
6. Add the following code:
Sub StartChat(ByVal contact As String)
Dim messenger As MessengerAPI.messenger
Set messenger = New MessengerAPI.messenger
messenger.InstantMessage contact
End Sub
Now you can call the StartChat Sub passing in the contact address like:
Call ")
The Messenger chat window will popup as you wanted.
Hope this helps. If you have any further questions, please kindly let me
know.
Thanks,
Jie Wang
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
.
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business days is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.