I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks

You have to check the value of the retain on retrieval setting prior to
trying to make the switch. Retain on retriveval must be set to false, or you
can not make the change.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks

Jim,
Could you give me an example please

"Jim Thomlinson" wrote:

You have to check the value of the retain on retrieval setting prior to
trying to make the switch. Retain on retriveval must be set to false, or you
can not make the change.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks

Give this code a try... Before you start go into Essbase options and uncheck
Suppress Missing and Suppress 0 and check retain on retrieval. Take a look to
see what teh options look like when you are done...

Sub TestSomeStuff()
Dim blnRetainOnRetrieval As Boolean

blnRetainOnRetrieval = EssVGetSheetOption(Empty, 11)

If blnRetainOnRetrieval Then _
Call EssVSetSheetOption(Empty, 11, False)

Call EssVSetSheetOption(Empty, 6, True)
Call EssVSetSheetOption(Empty, 7, True)

' with suppress set you can not chage the retain setting
End Sub

--
HTH...

Jim Thomlinson


"Nigel" wrote:

Jim,
Could you give me an example please

"Jim Thomlinson" wrote:

You have to check the value of the retain on retrieval setting prior to
trying to make the switch. Retain on retriveval must be set to false, or you
can not make the change.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks

You sir are a Genius

"Jim Thomlinson" wrote:

Give this code a try... Before you start go into Essbase options and uncheck
Suppress Missing and Suppress 0 and check retain on retrieval. Take a look to
see what teh options look like when you are done...

Sub TestSomeStuff()
Dim blnRetainOnRetrieval As Boolean

blnRetainOnRetrieval = EssVGetSheetOption(Empty, 11)

If blnRetainOnRetrieval Then _
Call EssVSetSheetOption(Empty, 11, False)

Call EssVSetSheetOption(Empty, 6, True)
Call EssVSetSheetOption(Empty, 7, True)

' with suppress set you can not chage the retain setting
End Sub

--
HTH...

Jim Thomlinson


"Nigel" wrote:

Jim,
Could you give me an example please

"Jim Thomlinson" wrote:

You have to check the value of the retain on retrieval setting prior to
trying to make the switch. Retain on retriveval must be set to false, or you
can not make the change.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks