Page 1 of 1
Vba code in tm1 active sheets
Posted: Tue Sep 10, 2019 2:42 pm
by 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.
Re: Vba code in tm1 active sheets
Posted: Tue Sep 10, 2019 4:19 pm
by 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.
Re: Vba code in tm1 active sheets
Posted: Tue Sep 10, 2019 6:21 pm
by spartan
gtonkin wrote: ↑Tue Sep 10, 2019 4:19 pm
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.
Re: Vba code in tm1 active sheets
Posted: Tue Sep 10, 2019 6:31 pm
by gtonkin
No code can be run in TM1 Web afaik.
Have a look at
this link for what is supported.
Re: Vba code in tm1 active sheets
Posted: Tue Sep 10, 2019 7:47 pm
by tomok
spartan wrote: ↑Tue Sep 10, 2019 6:21 pm
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.