Question Re: How? CMS data automatic export to Excel

Try to do early binding see if that works at least; in the VBA editor menu select Tools>References and look for one named Application Component and select it.

In your VBA code replace the below two relevant lines:

Dim cvsApp As ACSUP.cvsApplication .... instead of as Object

and

Set cvsApp = new ACSUP.cvsApplication ... instead of Set cvsApp = CreateObject("ACSUP.cvsApplication")

What happens if you do that?

Anther thing to check is your Windows Task Manger (CTRL + ALT + DEL). If you open it and see many acsApp.exe and acsSRV.exe processes running then it means you have a lot of Orphaned Objects in the memory due to running the VBA code to many times without proper garbage cleaning. Close CMS, terminate everything related to CMS from the processes and start again.

still the same error.

how to verify whether the ip address I am using is correct for Avaya?

When you log in the CMS application the server IP is above your user name and password box. Also the IP is displayed in the application above the menu when you are logged in as the title.

Check the IP make sure yours is CMS as per your code, if not change that part. Not many companies map the name CMS to the ip, usually it's an IP address!

I only seen this error with office 64 bit so not sure why you are getting it. Double check that office is 32 bit (not Windows).