× Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

How? CMS data automatic export to Excel

More
4 years 4 months ago #618 by roller
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.

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #619 by rahulr79
still the same error.

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #620 by rahulr79
how to verify whether the ip address I am using is correct for Avaya?

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #621 by roller
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).

Please Log in or Create an account to join the conversation.

Time to create page: 0.259 seconds
Powered by Kunena Forum