Outside of VBA, if I'm in Excel, I can click on a check box called "Retain on
Retrieval" under:
Essbase Options,
Mode tab,
Formula preservation title.

I need to find example code for doing that in VBA. When I do a retrieve in
the macro, it blows away some formulas. I need those formulas to stay put,
but I don't know the syntax of the code. Here are some examples of code I'm
currently using:

Declare Function EssVConnect Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant,
ByVal username As Variant, ByVal password As Variant, ByVal server As
Variant, ByVal application As Variant, ByVal database As Variant) As Long
Declare Function EssVDisconnect Lib "ESSEXCLN.XLL" (ByVal sheetName As
Variant) As Long
Declare Function EssVRetrieve Lib "ESSEXCLN.XLL" (ByVal sheetName As
Variant, ByVal Range As Variant, ByVal lockFlag As Variant) As Long

x = EssVConnect(Null, "userid", "password", "ipaddress", "database",
"database")
x = EssVRetrieve(Null, Null, 1)
x = EssVDisconnect(Null)

If anyone knows of a discussion group related to Essbase Programming let me
know....I didn't see one.
--
Thanks,
PTweety