My issues is simple. We are using SAS Financial Managment (SASFM)
which has custom functions to pull data. For Example
(=CDAGET("Management_View","Dimension1",node,"Dimension2",node,"Dimension3",node\
).
This will go out into the SAS database and pull the information based
on the formula.
What I want to do is have the formula in VBA pulling specific nodes
for the dimenions.
For example: Dimension1 = Organization, Dimension2 = Account,
Dimension 3 = Time. I don't want the formula to be in the spreadsheet
but only the final number .
Any ideas?