Macro for Saving Active selections in Bookmark object

[pavanthota]

Hi,

I have to create a macro which creates bookmark object saving the selections made in the QlikView document.

Can anyone help me on this macro

Thanks,

Pavan

[Gysbert_Wassenaar]

Sub AddBookMark

ActiveDocument.CreateDocBookmark false, "MyBookmark"

End Sub

[pavanthota]

Hi Wassenaar,

Thanks for your reply

Not only creation of book mark whatever the selections exist in QlikView document, those selection i want to save it in Bookmark through macro

Regards,

Pavan

[#4 · Accepted solution]

Hi Pavan,

See if this below code helps you

SUB GetSelectedValues

ActiveDocument.RemoveUserBookmark "savecurrentselection"
ActiveDocument.CreateUserBookmark "savecurrentselection"
ActiveDocument.ClearAll
       

END SUB

SUB RecallSelectedValues

ActiveDocument.RecallUserBookmark "savecurrentselection"
ActiveDocument.RemoveUserBookmark "savecurrentselection"

END SUB

Thanks,

Sarathi