Hi All,
After scouring the internet I have a macro set-up that will automatically run a report on Avaya CMS and save this to a directory with yesterday's date as the file name - this will be setup to run automatically each morning.
However at the moment, due to a limitation of CMS; I can only run the report for one "Skill" at a time (if anyone here knows much about call centres). I however would like to run the report for multiple "Skills" with each being appended to the bottom of the file until all the defined Skills have been run.
So for example, at the moment, the macro I have is duplicated 10-15 times with each having a different skill number - this then saves 15 individual files in a folder. I want this all in one big file, with each report pasted underneath the previous, with a blank row inbetween.
I have posted a sample workbook with the macro for running one report.
Bookmarks