Question Re: How? CMS data automatic export to Excel

Hi guys,

Is there any way to extract all agent group names from CMS to excel sheet?

I would like to build the drop down box to select the agent group in excel rather than in pop up CMS window because if on popup window you select CANCEL all extcel crashes and need to end task it

Cheers guys in advance for the help!

Hi, sorry for taking a while to reply. I've been trying to see if I can export the agent's groups names using VBA but I didn't have any luck.

You can add an agent group via VBA but to list all the names I couldn't get it done. In CMS the report that displays all the agent group doesn't have an export option. All the other CMS reports I exported via VBA in the past have an option to export which I used to trigger in VBA.

So unless if someone else can contribute I don't know how to help.

Hi there i tried with the code mentioned by you. I have put my user name and password. However when i run the macro it gives me error 424 object required. Not sure what that error means. I am not sure where shall i put the server ip address.
Please help.
I am trying to automatically pull the data from CMS and paste it in excel.

The sever ip or name should replace the two instances where you see "cms" in the code. For example if your server ip is 10.123.123.123 then use "10.123.123.123" with the quotation marks around it.

If you tell us which line of code the error is occurring it might help.

Thanks for your reply.
I am bit confused in this as i am not very good in Macros.
What i am trying to do is, automatically pull the data from CMS -> Historical ->Designer-> Skill data /w Max delay and paste it in Excel.
For this i was looking for a code.

Appreciate your help

I feel your pain however we don't offer full solutions in this forum and we assume that you have some VBA experience. What you are asking has been covered in othr posts.

There are at least 4 or 5 forum posts on this site with full solutions to what you are asking for, they are aalmost identical. Please read the other post and try to give it a shot.