Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
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.