Quote:
Originally Posted by smndnm
I don't want to open the PDFs, I need to batch process them to apply security settings, it is an attempt to open an instance of Adobe pro locally if not already open.
|
In that case, you'd probably do better to automate Acrobat Pro (assuming that's what you're using).
Quote:
issue1 = It throws an exception at the"msoFileDialogFilePicker" stage when the user presses cancel. I cannot make the previous solution work (If .Show = -2 Then Exit Sub).
Issue2 = It doesn't remember the variable "target1" when I save the PDF and thus won't select the chosen location. it works when all docs are local on my laptop, but it has fallen over when it tested on the network.
|
These issues could be avoided if you used the function I provided you with instead of your first call to the file dialogue. All you'd need to call the Function with is:
target1 = GetFolder & "\"
If target1 = "\" Then Exit Sub