Bookmark macro doesn't apply before export occurs.

markmccoid — Mon, 25 Oct 2010 17:41:45 GMT

I have the following Macro where I'm trying to load a bookmark and then call another function that loops through a field, exporting XLS files.

sub ExportDriver
ActiveDocument.RecallDocBookmark "Test2"
call AML_PrintToExcel("vExportLocation", "ExportChart", "AccountNumber_AdBase")
end sub

The problem is that the export finishes before the bookmark is applied, hence I get more information than I want.

It works fine on small datasets, but when it gets larger, I get the situation where the information is exported before the bookmark applies.

Has anyone experienced this or better yet, found a solution?

pover — Mon, 25 Oct 2010 18:13:49 GMT

After recalling the bookmark inset the following line so that the macro waits for the bookmark to be applied.

ActiveDocument.GetApplication.WaitForIdle

Regards.

topic Bookmark macro doesn't apply before export occurs. in QlikView