Problem with macro running on MS Server 2003

[#1]

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

[disqr_rm · Accepted solution]

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.

[#3]

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

[disqr_rm]

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.