Call a macro from the load script.

[#1]

Hello,

I am calling a macro from my load script to read a configuration file.

It works perfectly in the Local client , using qv.exe at command line , but fails when I use the QlikviewDistribution.exe executable.

I am using this program like that :

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\Documents and Settings\philippe\Bureau\HUBIZ_svn\Projets\ProfitMasterCanada\QVW\Hubiz_Profitmaster.qvw" -variablename=ConfigurationFile -variablevalue="'C:\Documents and Settings\philippe\Bureau\HUBIZ_svn\Projets\ProfitMasterCanada\QVW\Hubiz-properties'"

But it always fails with that message :

21/05/2010 8:21:18 AM Information 05/21/10 08:21:18: 0014 Repertoire=GetE
nv('Directory', 'C:\ProgramData\QlikTech\Documents\hubiz-properties')
21/05/2010 8:21:18 AM Information 05/21/10 08:21:18: 0017 directory ERROR
: Testfile, unable to create FileSystemObject

Is there anything parameter to activate to make it work.

I am using Version 9 SR3.

Thanks

Philippe

[#2]

Phillippe,

may I inquire what the outcome was of that support request You mentioned in your last posting? I think I have a similar problem.

Thanks!

Best Regards
Jens

[#3]

The answer is :

Normal 0 21 false false false FR X-NONE X-NONE MicrosoftInternetExplorer4

Here is the response from Brett.

Working as designed, Publisher ignores all macro calls, and it always has been this way. It seems you are doing an OnOpen trigger more than likely from what I can tell, and if so, this will never work via Publisher. You would need to use a Windows Scheduled Task to call Qv.exe /r in this case to accomplish things and/or redesign things such that the macro is not needed.