HELP!! CMS Avaya data imports to Excel 2010

**HolySeph** · 04-18-2013, 08:56 AM

I have to do an interval report every hour for my company, and it requires me to constantly switch (alt+tab)between Avaya CMS & Excel. I generate data one at a time from each split (over a dozen splits) in CMS and copy it, then paste it one by one to Excel. I'd like to form a quick-n-easy method to do this with one macro.

Thanks,
James

**HolySeph** · 04-18-2013, 12:08 PM

***bump***

**KuyaGibs** · 05-01-2017, 10:03 PM

UP!!

Anyone who knows? I might also need this. Please help.

**protonLeah** · 05-01-2017, 11:27 PM

KuyaGibs,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

**Walls** · 07-26-2017, 06:08 AM

I do a lot of interval reporting so you've got a couple of options.

Why not open the CMS report, go to design, Edit, Edit Inputs and click the split skill multi value button. Then you can run one report with multiple splits.
You could also script the report to output to a text file and import the data into Excel with some VBA.
OR
You run the VB code from the Avaya ACSAUTO script in Excel as a macro.