Need syntax for Spread , Trend , weight function of EPM using VBA

[Former Member]

Hi

How to use EPM->(Spread , trend , weight ) function using VBA?

[former_member186338 · Accepted solution]

Hi Ashray,

Just open help for EPM - "42.5.17 Spread, Trend, Weight"

All functions use no parameters!

All will open a dialog box...

Vadim

[Former Member · Accepted solution]

Hi Vadim

Thanks for your revert. I tried "help browser" but I cannot find VBA syntax for it but instead this function was explained there theoretically.

Can you please tell in more details?

Thanks in advance

Ashray Beohar

[former_member186338 · Accepted solution]

Hi Ashray,

Not theoretically Try yourself!

If you have:

Dim epm As New FPMXLClient.EPMAddInAutomation

epm.Trend

Then this code will open Trend dialog box!

Vadim

[Former Member · Accepted solution]

Hi Vadim

Thanks this worked for me .

But is there any way to provide input to these functions , passing parameter in VBA to make it fully dynamic.

Presently even though its got triggered & gave a dialog box , but spread is still to be done manually further.

Thanks in advance

Ashray Beohar

[former_member186338 · Accepted solution]

"But is there any way to provide input to these functions , passing parameter in VBA to make it fully dynamic." - no way, you can't provide ANY parameters!

But you can write trend or spread equivalents in VBA yourself! It's absolutely easy!

Vadim

[Former Member · Accepted solution]

Hi Vadim

Ok , Thanks a lot.

Regards

Ashray Beohar

[former_member186338 · Accepted solution]

For Trend / Spread you don't need any BPC functionality - just some calculations with Excel cells. Read value from some cell and divide it between range of other cells!