Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I got a sheet of employees in Excel 2010 and would like to see who's online on Communicator jst by looking at the sheet and the row with employee's name. Each employee has the firm's email address in the sheet, of course.

How can I access this information from communicator from VBA/cell perspective?

share|improve this question
    
Have you got smart tags turned on (under auto correction) –  Rhys Gibson May 23 '11 at 20:48
add comment

2 Answers

You'll have to write a VBA script (or .Net/any other language plugin) that uses the Communicator Automation API. It's probably one call per user ID.

share|improve this answer
    
do you have any example of usage? I can't see any relevant examples / resources for this MC communication across VBA in there. google didn't help a lot –  Greenleader May 23 '11 at 10:15
    
I don't have specific sample code, but it shouldn't be different than other Office classes. If you do need a consultant to write the code for you (hint hint :) ) –  Traveling Tech Guy May 23 '11 at 19:04
    
yeah, the project is my-position-need oriented. guys around here at company do not care about automation. Also a reason I'm quiting the company - dell. :) –  Greenleader May 24 '11 at 6:11
    
Hah. Are you in Austin? These guys used to be my customers. Cool bunch. Good luck! –  Traveling Tech Guy May 24 '11 at 8:39
add comment

The blog in this page explains how to get User status is Online or Offline in Office Communicator.

Get User Status From Office Communicator

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.