TM1 Forum

Hi,

Thanks for your tips, it sent me in the right direction It turns out the following command was dropped from TI process for some reason, ViewExtractSkipCalcsSet.

I've had another process that after saving it lost some of the code. Fortunately I have backups, but why would this happen?

Hi, I've had a chore setup up to output a view daily. This view has a single value only and up until last week it worked fine. Now it creates no output file at all. There is data in that view, I can see it in the preview section on the datasource tab. I tried moving the piece of code to the Prolog t...

Hi All,

Has anybody experienced a noticeable lag in selecting cells in Excel 2007? When I disable the ribbon, the lag goes away.
Any ideas?

Thanks in advance.

Yay !

Thanks Brandon

I used the hUser as the session handle and it works.

Hi Brandon, Thanks for your reply ! The code fails on the session handle as you suspected because the user is not logged into TM1 through Excel. Does a user really need to log in to run a VBA process since the 'admin' is already successfully logged in? ('....MsgBox "You Logged in Successfully&q...

HI All, I have the following snippet of code that I found on this board, however it is not running the process, I am getting a successful connect though. Could anybody shed some light as to what I'm doing wrong? Option Explicit Global arr() Declare Function TM1_API2HAN Lib "tm1.xll" () As ...