Search This Blog

Friday, May 29, 2015

BAT and 64-bit Excel

Lately, I've been seeing some people have issues when trying to use BAT on CUCM.  When you open the excel file you have macros and all that jazz needed to start whipping up a spreadsheet for import.  Normally this works without issue but now that systems are going pure 64-bit, there is really no need to make 32-bit applications.

So what is the problem you might ask?  The biggest issue is that Cisco has not developed their BAT file to work on 64-bit Excel.  This can cause headaches as large phone deployments suck without BAT.  Fear not however, there is a work around that a clever gentlemen on another website had posted to fix the issue.  The only problem with this solution is that you have to keep making the change to the visual basic file to get everything to work each time you open a BAT sheet.

Go here: 64-bit Excel Fix

Again, this isn't my work but a solution I found and posted on the Cisco support forums when the issue came up.  It makes life easy because hand jamming 283 phones sucks and you will be in a hand brace the next day if you go that route.  Oh and by the way, I passed my CIPT1 exam.  Two left and I am preparing to take both of them back to back.

No comments:

Post a Comment