topic Re: exporting bookmarks in QlikView

exporting bookmarks

Mon, 12 Sep 2011 15:34:29 GMT

I am trying to export bookmarks from within an application (see code below). It works on PCs where the user has dev access (i.e. unrestricted access to the folders) but fails for the majority of the standard users. In the example below, we are trying to write to the root drive. Does QV has a capability to retrieve the temp or tmp system variable as most users have write access to that directory and we have a combination of windows XP and Windows 7 - so temp folders are in different locations -

Many Thanks

sub Module1

ActiveDocument.CreateDocBookmark true, "MOBS-EXP_1"
ActiveDocument.ExportBookmarks "c:\MODULE1.qbm"
ActiveDocument.RemoveDocBookmark "MOBS-EXP_1"

end sub

Re: exporting bookmarks

Miguel_Angel_Baeyens — Mon, 12 Sep 2011 16:25:05 GMT

Hi,

Something like the following should do

     Set objShell = CreateObject("WScript.Shell")
     Set sysvarTemp = objShell.Environment("TEMP")

Now you can use the "sysvarTemp" in your paths.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: exporting bookmarks

Thu, 15 Sep 2011 07:15:54 GMT

Many Thanks Miguel,

Exactly what I wanted.

Kind Regards

Haider