02-26-2010 06:48 AM - edited 03-15-2019 09:33 PM
Hi,
We recently upgraded CUCM to 7.1 (7.1.3.30000-1 exactly). When we were running 6.1 I had no problem using the BAT spreadsheet. Since we did the major upgrade I decided to download the new version of the BAT spreadsheet. I am running Excel 2007 (which, btw, was upgraded at about the same time the CUCM upgrade occurred, coincidentally. I think I was running Excel 2003 before that.)
Now when I try to 'Create File Tile' on the "Phones" tab or when I try to 'Export to BAT Format' on the Phones-Users tab (on which I could execute a Create File Tile, interestingly) I get a Microsoft Visual Basic error stating "Compile Error: Method or data member not found" and .TxtNoofLines in the text (Sheet1.TxtNoofLines.Text) is highlighted, suggesting that .TxtNoofLines is what cannot be found. You can hit 'Ok,' but then it brings you back to the spreadsheet and doesn't do what you wanted.
I went into the Excel Trust Center and selected "Enable All Macros," so I don't think that is the problem.
Thanks - Rob.
05-17-2011 09:35 AM
I have the same exact issue with the bat file and the Microsoft Visual Basic error stating "Compile Error: Method or data member not found" and .TxtNoofLines in the text (Sheet1.TxtNoofLines.Text) is highlighted.
I get the same error on two different machines.
Not quite sure how I can get the bat file exported and get around this error.
Anyone have a resolution/workaround to the original question ?
TIA
10-15-2012 10:04 AM
I'm also experiencing this issue...were you ever able to find the solution?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide