topic Re: Set PreserveScrollPosition with Macro for Straight Table in QlikView

Set PreserveScrollPosition with Macro for Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please can someone help me with this.

How can the Preserve Scroll Position property on a straight table be changed using VBA?

I have found this following code using the API Guide, however it only seems to work with the Table Box object and not with the Straight Table object.

set mybox = ActiveDocument.GetSheetObject("LB01")

set mbp = mybox.GetProperties

mbp.Layout.Frame.PreserveScrollPosition = true

mybox.SetProperties mbp

Thanks.

Tue, 28 Mar 2017 14:30:52 GMT

I have worked out how to do this.

Just need to change Layout to GraphLayout!

set mybox = ActiveDocument.GetSheetObject("CH102")

set mbp = mybox.GetProperties

mbp.GraphLayout.Frame.PreserveScrollPosition = true

mybox.SetProperties mbp

m_woolf — Tue, 28 Mar 2017 15:19:30 GMT

Try:

set mybox = ActiveDocument.GetSheetObject("CH01")

set fr = mybox.GetFrameDef

fr.PreserveScrollPosition =true

mybox.SetFrameDef fr

Wed, 29 Mar 2017 14:06:12 GMT

Thanks, m w, your code works too.