In production (8.2.12), Citrix users run a batch file which fires up Excel, loads the tm1p.xla add-in and the Beachware 7.0 add-in. Essentially:
Code: Select all
call "C:\Program Files\Microsoft Office\Office10\Excel.exe" "\\ServerName\TM1\Client\Programs8212\tm1p.xla" "\\ServerName\TM1\client\beach\beach.xla"
Try that in version 9.1, though, and:
- The tm1p.xla displays its macro warning and the add-in loads as usual.
- The beach.xla displays the macro warning and...you get an unhandled VBA error 91, object not set.
When you go to log in to the server, you'll get another error 91 followed by a dialog telling you that a macro error has occurred, but after that it'll perform normally. (Except that the connection lamp on the TM1 toolbar will remain red; this would seem to be what's interacting toxically with Beachware.)
The workaround: The first time you load Beachware you need to do it manually. It seems OK with being loaded after the tm1p.xla has been loaded and settled in, it just doesn't like to move in to la casa di Excel at the same time. In subsequent sessions, the beach.xla add-in will load when the user clicks on one of its toolbar icons.