Excel macros and action buttons

[Joffes]

Hi guys,

I need to add an amount of vb code to a cube slice, this code will run through command buttons, however these as we know are not supported in Tm1Web.
I am using Excel 2007 and 9.4.1 FP 2

My questions are:
Is there a way of running a macro through action buttons?
Is there another method of using these macros in web?
Can this be done using the API, if it is spreadsheet dependent?

Thanks in advance
Steve

[David Usherwood]

You can't run VBA in TM1Web because it's not running Excel (which hosts VBA).
But you can put VBA behind a normal Excel button or commandbar. This will work fine.
Action buttons were thought up as a (very) partial fix to running code in both TM1 and TM1Web. My take is that for full service apps Excel is better (delivered by Citrix if necessary).

[lotsaram]

It might help to give some explanation as to what your VBA code is doing and what you need it for.

As noted here already (and many other places on this forum) VBA macros are not supported in TM1 Web but maybe you don't need macros to do what you are wanting to do. There are plenty of options that don't require VBA that might do the same thing such as running a TI process, navigating to another report, drilling through to another report or transactional data, filtering or sorting a report. If you give some more information on what it is you are wanting to do you might get some more useful tips on how to do it.

[Joffes]

Thanks guys,

I understand VBA is not supported and why it will not work on web.
I am just trying to see if there is some type of workaround using action buttons.
My client has many excel reports and input templates where we use excel buttons and vba to add and remove lines in the sheet and limit what the users can do, I would like to keep that functionality when they go live on Web, if its possible.

Cheers
Steve