TM1 Forum

Howzit

Thanks for the speedy reply - much appreciated. I've had a quick look and it looks like it could be just what I am after.

I guess I know what I'll be doing this weekend...

Good morning all TM1 Client 9.4.1 Apologies if this has been answered before, but I can't seem to get the right answer from searching the forums. We have a view (monthly) that we slice to Excel (zero suppression), that returns the required data set for the month. This is an entirely manual process. ...

Hi Wim You solution worked an absolute treat, and is definitely more readable. There was a slight issue with the code in regards to the filename as workbookfilename returned an empty string fname = path & Split(workbookfilename & ".", ".")(0) & "-" & .Na...

Hello everyone We have some vb code that saves all the tm1 sheets in a file into csv files. Upto now the user had been manually clicking on OK to save the sheets. I thought I could change this by turning off displayalerts as part of the process. This works just fine when I am not connected to TM1, b...