TM1 Action Button

[jonathan.d]

Hi,

Is there a way to access the TM1 action button through a macro?

[Wim Gielis]

Hi Jonathan

Can you elaborate a bit more on your question? What do you want to achieve in VBA?

In fact, the button itself is a shape, so it can be controlled using VBA.

Wim

[jonathan.d]

Hi,

I want to be able to call a workbook from another, copy sheets over to the first workbook, then close the second one which was opened.

Both workbooks would be sitting on the server under the applications folder.

I am guessing TM1 doesn't treat an action button as a normal command button, although when you click on it with controlbox enabled...the formula bar shows
'=EMBED(TM1XL....etc.)

I want my macro to do what the action button should do and then something more.

[Wim Gielis]

Hello Jonathan

Maybe I am missing something important in your story, but couldn't you use a second action button? That action button could point to another process. This process would start off by executing the existing process (you can use an ExecuteProcess statement in the Prolog for that), and then it would do "something more" as you call it.

Wim

[jonathan.d]

Hi Wim,

I found a post from last year from a user who had the same problem as myself.

The issue was never resolved.

Here's the link.

http://forums.olapforums.com/viewtopic.php?f=3&p=1101



Thanks!

[Wim Gielis]

Hi Jonathan

I have not yet worked with blob in the TM1 API. If I might in the future, I will take up this challenge. But don't expect that to be soon.

Wim