TM1 Forum

Posted: **Tue Feb 17, 2015 11:22 pm**

Hi, All

When we upgraded into 10.2.2, I found that the undocumented VBA macro is not working anymore, such as TM1StartOrionWithAutomation or CUBES_BROWSE.

undocumented TM1 macros:
TM1RECALC1 : same as shift-F9, refreshes only the active worksheet
TM1RECALC : same as F9, refreshes ALL open workbooks
TM1REFRESH : same as Alt F9, rebuilds (dynamic spreadsheets) and refreshes ALL open workbooks
TM1StartOrionWithAutomation : opens Server Explorer
CUBES_BROWSE : opens Server Explorer
SUBDELETE: deletes a subset (if unused) ex: Application.Run("SUBDELETE", "myserver:account", "MySubset")
TM1InsertViewControl : starts In Spreadsheet browser
TWHELP : opens TM1 perspectives help
TWDEFAULTS : opens TM1 Options menu
TWMERUL : opens rules worksheets menu
TWMEDIM : opens dimensions worksheets menu
to be continued...

When I use it in VBA, it pops up with following error:

Posted: **Wed Feb 18, 2015 12:48 am**

macsir wrote:Hi, All

When we upgraded into 10.2.2, I found that the undocumented VBA macro is not working anymore, such as TM1StartOrionWithAutomation or CUBES_BROWSE.

Those are very much "use at own risk", as I'm sure you're aware. But that having been said I'm able to run that macro with a 10.2.2 32 bit add-in in 32 bit Excel.

Are you perchance using the 64 bit add-in instead? Because I'd bet that that sucker was have been rewritten from the ground up and it'll be unsurprising if a lot of undocumented (legacy) functionality will have vanished from it.

Posted: **Thu Feb 19, 2015 11:50 pm**

Alan Kirk wrote:
macsir wrote:Hi, All

When we upgraded into 10.2.2, I found that the undocumented VBA macro is not working anymore, such as TM1StartOrionWithAutomation or CUBES_BROWSE.
Those are very much "use at own risk", as I'm sure you're aware. But that having been said I'm able to run that macro with a 10.2.2 32 bit add-in in 32 bit Excel.

Are you perchance using the 64 bit add-in instead? Because I'd bet that that sucker was have been rewritten from the ground up and it'll be unsurprising if a lot of undocumented (legacy) functionality will have vanished from it.

Thanks, Alan. That is resolved by reinstalling excel. Reinstalling TM1 doesn't help.

Posted: **Sat Feb 21, 2015 1:53 am**

Error message suggests excel can't reference the library containing the CUBES_BROWSE function. Unlike the public methods contained in the addin like tm1p.TM1RPTShowFormatArea or tm1p.TM1RebuildCurrentSheet, I think excel occasionally loses the object handle in memory.

I don't have 64 bit excel, but my guess is the addin(s) will still have the same function calls to xll and dll conditionally compiled for win32 or win64 architecture.

yay! my 100th post.

TM1 Forum

VBA TM1StartOrionWithAutomation or CUBES_BROWSE not working

VBA TM1StartOrionWithAutomation or CUBES_BROWSE not working

Re: VBA TM1StartOrionWithAutomation or CUBES_BROWSE not work

Re: VBA TM1StartOrionWithAutomation or CUBES_BROWSE not work

Re: VBA TM1StartOrionWithAutomation or CUBES_BROWSE not work