Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

SAS CDAGET function to use in VBA

  Asked By: Kristopher    Date: Mar 10    Category: MS Office    Views: 1530
  

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?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on SAS CDAGET function to use in VBA Or get search suggestion and latest updates.




Tagged: