Forum Discussion

ianreid's avatar
ianreid
New Contributor III
3 years ago

Using OneStream Excel VBA functions

Do the OneStream Excel VBA functions return a value that can be used to determine success or failure?  For example, I am loading data to a cube using a sheet with a number of XFSetCell() formulas and...
Excel Add In
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

Well, if it's a Function it will return something, if it's a Sub it will not... I don't have the add-in at hand at the moment, but intellisense autocomplete in your macro editor should tell you which one it is. (Edit: actually not, in the regular VBA editor; one would have to use the proper Visual Studio or equivalent.)