Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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();
can you please send me the demo applcation because i am also dong the same thing but i am getting null in the variable
Example attached. And here is another example.
Can i also deactivate the Bookmark using macro
ActiveDocument.ClearAll will clear all selections. That 'deactivates' the bookmark.
ActiveDocument.RemoveBookmarkById "BM01" will remove bookmark BM01 entirely.
Any example of macro?