CUCM BAT file

[Ali Alqwasmi]

Dears,

Good day...

I have an issue with Excel BAT file downloaded from CUCM. I want to export BAT file for adding new users. everytime I proess on the "Export to BAT Format" Button I get an error message from Excel "Run Time Error (13): Type Mismatch". When I click on Debug I find the following line in the VBA highlighted with yellow color:

If Trim(Range(getRange(intCount) & Trim(Str(i))).Value) <> "" Then

Can you please advise where is the mismatch? and how to correct it in order to export the BAT correctly.

Many thanks

Ali Alqwasmi

[Manish Gogna]

Hi Ali,

Can you set the Regional setting on the Windows PC ( Under Control Panel )  to 'English ( United States )' and test again.

Manish

[Ali Alqwasmi]

Hi Manish

I found out what was the problem.

some of the names in the "Last Name" Field had spaces in them which caused the error to show. I removed the spaces and it worked fine.

Many thanks

Ali