0
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?
Greenleader
Posted 2011-05-23T05:30:04.360
Reputation: 446
1
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.
Traveling Tech Guy
Posted 2011-05-23T05:30:04.360
Reputation: 8 743
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 – 2011-05-23T10:15:23.160
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 – 2011-05-23T19:04:28.550
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 – 2011-05-24T06:11:48.987
Hah. Are you in Austin? These guys used to be my customers. Cool bunch. Good luck! – Traveling Tech Guy – 2011-05-24T08:39:26.393
0
The blog in this page explains how to get User status is Online or Offline in Office Communicator.
Guest
Posted 2011-05-23T05:30:04.360
Reputation: 1
Have you got smart tags turned on (under auto correction) – Rhys Gibson – 2011-05-23T20:48:02.280