TM1 Forum

OK understand, thank you One more question. Now I see that inside company VBA is first prompting me to pickup server/application, but after doing that it's redirecting me to another window (looking as flash window) where I insert my ID/password (probably from website where company stores employees I...

...or maybe, do I need to copy declare functions into blank sheet all the time?

...probably not yes, as those functions are preloaded by default when I open any ssheet... ?

Hi Andy, thank you, tried your connection code that is calling N_CONNECT macro. It's not doing anything for myself even if I leave server, user, Pass empty it's doesn't bring up login window (which it probably should do right?) Can it be that my TM1 functions/macros that are doing connection (functi...

.... I understand that the connection macro is somewhere inside the VBA modules that I have already inside excel VBA explorer, just can't find it.....

Hi, sorry if this is already described somewhere, but I couldn't find it. I was able to identify how to refresh/refresh all sheets using TM1 cognos, but so far didn't find the way how to automatize the connection to server when using TM1. I know how to connect using Essbase software, but now switchi...