TM1 Forum

For xls and xla formats 1. Open the file with a hex editor. I use freeware HxD because it was included in the LiberKey Suite. 2. Do a string search for "DPB" and replace that with "DPx". 3. Save the file with a new name so you do not overwrite the original. 4. Open the xls/xla wi...

I'm not sure if this is comprehensive but here is a list of all the VBA TM1 Calculation options that I use Application.Run "TM1RebuildCurrentSheet" 'activeform sheet rebuild "Alt & F9" Application.Run "TM1Refresh" 'activeform sheet rebuild "Alt & F9" A...

Not sure if this would be useful for others but it also resets TM1 window sizes. Tested on Windows 7 64 bit. Use at your own risk/discretion. I accept no liability if you use this code. vbScript '''optional agruements for opentextfile '' True is Unicode, False is ASCII, Default is system default, om...

'' called by the old OnEntry event model, replaced by SheetChange but left in for compatibility '' with pre-existing recorded macros Public Sub TM1UPDATE() '' Application.EnableEvents = False '' Application.Run ("TWEVUPDATE") '' Application.EnableEvents = True End Sub Anyone care to follo...

just a thought and I have not tried, but could you change the default styles in excel
http://www.pchelps.com/2011/03/producti ... ormatting/

Hi, My first post here and I'm pretty new to tm1 (6 months). I have a question regarding looping through activeforms with vba and rebuilding them. I'm having trouble getting the activeform to complete the rebuild prior to going to the next sheet resulting in activeforms that have not been rebuilt. B...