Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exporting bookmarks

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

2 Replies
Miguel_Angel_Baeyens

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

Not applicable
Author

Many Thanks Miguel,

Exactly what I wanted.

Kind Regards

Haider