Load from Windows' environment variables path?

[#1]

Did some Googling but couldn't find this answer .. does anyone know if data sources can be referenced using Windows environment variables to define the path?  Eg  %HOMEPATH%  = \Documents and Settings\{username}

[rbecher · Accepted solution]

Hi,

I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:

let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');

LOAD *

FROM $(vPath)\test.qvd (qvd);

- Ralf

[#3]

Thanks Ralf that is as good as!