Using Windows Environment Variable from Macro?

[#1]

I want to be able to use a Windows Environment variable (i.e. TEMP) from Macro. Want to specify where my exported file is located. Is this possible?

ActiveDocument.GetSheetObject( "Check01Chart01" ).Export "$(TEMP)\test01a.csv", ","

[#2]

I believe there is a method called ExpandEnvironmentStrings. Sorry don't have any example code, but I'm sure it's easy to google-

[#3]

Thanks, but googling on QlikView & ExpandEnvironmentStrings does not return any information on such a function.

[llauses243]

Hi ,

Moreover atach .vbs

Then is possible to pass %TEMP% to variable.

Goos luck, Luis

[#5]

Hi,

You can do same with less lines from script

EXECUTE cmd /C "set > var.txt" ;
LOAD
 @1 as var_name,
 @2 as var_value
FROM [var.txt] (txt, codepage is 1252, no labels, delimiter is '=', no quotes);

-Alex

[#6]

Add the code to the script but now getting the warning dialog below and I can't figure out where to "permanently check the Execute option for the script". Where do I set the execute option? Thanks.

[#7]

Open script, there is setting "can execute external programs"

-alex

[#8]

Another script-based method which doesn't use temporary files is to query the environment variables directly from the registry:

LET env_var_value = GetRegistryString('HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment', 'env_var_name');

Simon