Using VBA in excel to export data from Avaya CMS

Hi guys,

I'm totally stumped on this one. I'm trying to run a report from Avaya CMS using excel. I've been told it can be done but I can't find much on it in the Avaya forums apart from some code which purports to do what I want. The code is as follows:

Please Login or Register  to view this content.

I've changed the variables so you don't have my log in details!

I keep on getting an error saying that excel is waiting for another application to perform an OLE action. Has anyone come across this before? Not sure whether this is a problem with the code, excel or CMS. If it's the latter then I apologise for posting to this forum.

Thanks, Chris