Vba code in tm1 active sheets

[spartan]

Hello All,

I need to write a vba code in one of my active sheet. So do i need to save in xltm or xlsx?

Do tm1 support .xltm sheets.

Can anyone help me out.

[gtonkin]

If you will be consuming on TM1 Web, you cannot use macros.
If not, you probably want .xlsb or .xlsm
If you are publishing to applications, go with .xlsm, .xlsb can be trickier to keep updated.

[spartan]

If you will be consuming on TM1 Web, you cannot use macros.
If not, you probably want .xlsb or .xlsm
If you are publishing to applications, go with .xlsm, .xlsb can be trickier to keep updated.

Hello,

Yes i use Active sheet in tm1 web as well.

So if we use the active sheets in tm1 web, we can not use macros in them?? So the answer would ba a No. Or is their any other possibility.

[gtonkin]

No code can be run in TM1 Web afaik.

Have a look at this link for what is supported.

[tomok]

So if we use the active sheets in tm1 web, we can not use macros in them?? So the answer would ba a No. Or is their any other possibility.

The answer is unequivocally no. TM1Web can not run VBA code. If you can't do it through a combination of Excel formulas and action buttons then it cannot be done.