topic Macro Nad Bookmark in QlikView

Macro Nad Bookmark

Wed, 24 Oct 2012 13:21:42 GMT

Hi Guys

I have a book mark in my qvw, now i want to export to excel the straight table in that bookmark using macro

Re: Macro Nad Bookmark

Gysbert_Wassenaar — Wed, 24 Oct 2012 13:47:16 GMT

It's possible to create a macro that activates a bookmark and then exports a table to excel. Here's an example with a macro to export an object to excel.

To activate a bookmark add these two lines:

ActiveDocument.RecallDocBookmark "TestBookmark"

ActiveDocument.GetApplication.WaitForIdle

Re: Macro Nad Bookmark

Wed, 24 Oct 2012 17:53:52 GMT

Thanks Gysbert... it is really helpful .. i just want to ask you one more thing...

Can i call a Macro sub or function in my script........ ??????????????

i tried to call a macro function in the script and get the value that function in variable but it is coming NULL

Can you please help me regarding this

Re: Macro Nad Bookmark

Gysbert_Wassenaar — Wed, 24 Oct 2012 18:09:03 GMT

Yes you can, but it has to be a function, not a sub. This will call a macro called MyFunction and return the result to vMyVar

Let vMyvar = MyFunction();

Re: Macro Nad Bookmark

Wed, 24 Oct 2012 18:17:21 GMT

can you please send me the demo applcation because i am also dong the same thing but i am getting null in the variable

Re: Macro Nad Bookmark

Gysbert_Wassenaar — Wed, 24 Oct 2012 18:25:56 GMT

Example attached. And here is another example.

Re: Macro Nad Bookmark

Wed, 24 Oct 2012 18:56:45 GMT

Can i also deactivate the Bookmark using macro

Re: Macro Nad Bookmark

Gysbert_Wassenaar — Thu, 25 Oct 2012 08:11:48 GMT

ActiveDocument.ClearAll will clear all selections. That 'deactivates' the bookmark.

ActiveDocument.RemoveBookmarkById "BM01" will remove bookmark BM01 entirely.

Re: Macro Nad Bookmark

farolito20 — Wed, 09 Jan 2013 21:07:24 GMT

Any example of macro?