TM1 Worksheet Function

[appleglaze28]

Can you use TM1 Worksheet Function in your VBA script as any regular Worksheet Function? Are there extra parameters or script you need to write to make it work?

Any useful tips or best practice guide you guys can share with a beginner when utilizing TM1 Worksheet Function via VBA?

[Alan Kirk]

Can you use TM1 Worksheet Function in your VBA script as any regular Worksheet Function? Are there extra parameters or script you need to write to make it work?

Any useful tips or best practice guide you guys can share with a beginner when utilizing TM1 Worksheet Function via VBA?

You use the Application.Run method.

For example:

Code: Select all

MsgBox Application.Run("DBRW", "Server:Cube","Element1","Element2")

The first argument is the function name, then each of the arguments that you would pass to that function.

This is different from using standard Excel functions, which usually use either the WorksheetFunction property of the Application object, or (undocumented) use the Application object directly.

[appleglaze28]

Okay...so the only difference would be adding the Applicaton.Run as well as the ServerName should always be included if I'm gonna base the parameters for the Function in the Reference guide.

[Alan Kirk]

Okay...so the only difference would be adding the Applicaton.Run as well as the ServerName should always be included if I'm gonna base the parameters for the Function in the Reference guide.

You need to use the server name regardless of how you're using the function, unless you're running a local server.

The primary difference is that the function name itself is the first argument that you pass to the Application.Run method.