Question Excel VBA macro automate Avaya CMS agent groups

[quote=http://www.mrexcel.com/forum/excel-questions/534416-changing-avaya-agent-skills-excel-visual-basic-applications-2.html[/quote]

I wrote the above link, the best way to accomplish adding reps to the avaya groups is by using the sendkey method posted earlier. Unfortunately there is no way to code the options needed to add and remove in the avaya language.

You'll have to remove the website link but here is the file I used to use to update the avatar groups

I guess that's one way to do it Without the Avaya VBA library. Send keys is thinking outside the box. Is it reliable 100% of the time?

Changing the skills of existing agents is easy but not adding new agents. I guess another method of you have access to the avaya database via the odbc connection is to just write directly to the tables. However many IT departments won't allow you access.

Thanks for sharing your solution.

It's reliable as long as you don't try and do any other tasks while it runs. Only hard part is narrowing the entries to maximum limit for the avaya screen. But the sendkey method works great.