topic Problem with macro running on MS Server 2003 in QlikView

Problem with macro running on MS Server 2003

Mon, 17 Aug 2009 21:28:12 GMT

I've written a macro to export a report to PDF, this works fine when I run it on my pc however when i run it on the server it prompts me with a 'Save as' box.

Any ideas?

My code is attached.

Thanks

Helen

Problem with macro running on MS Server 2003

disqr_rm — Mon, 17 Aug 2009 21:32:49 GMT

Try commenting lines which are resetting registry keys:

WSHShell.RegWrite RegKey & "BypassSaveAs", 0
WSHShell.RegWrite RegKey & "OutputFile", ""

And after execution check if it is able to make registry changes. Could be authorization problem with the user running this job on the server.

Problem with macro running on MS Server 2003

Mon, 17 Aug 2009 21:37:50 GMT

Hi,

That seems to have worked, thanks! I took the macro from the fourm - do you know why those 2 lines would normally be inculded, it seems to be working fine without making the registry changes.

Thanks

Helen

Problem with macro running on MS Server 2003

disqr_rm — Mon, 17 Aug 2009 21:49:25 GMT

Those lines are restting registry values back to original. If you leave those commented, the user will never be givin popup for "Save As", which may not be good in your case. Atleast, you know where to dig-into now.