Run-time error using PdfSettings.OpenViewer setting


#1

I’m writing some Excel code to generate a password protected PDF using VBA. It’s working so far except I don’t want the current PDF viewer opening after the file is saved. However, when I add the following line to my script, I get an run-time error:

PrintJob.SetProfileSetting "PdfSettings.OpenViewer", "false"
PrintJob.ConvertTo SavePath

image

At this point, Excel is broken and I have to exit Excel and re-load. Comment the line out and it works fine.


#2

Ahh just realised by single stepping through that the error is on the setting of the profile string, not the convert. What’s wrong with the SetProfileSettings line?


#3

Okay, got it sorted. One assumes that all settings were of the format “PdfSettings.something” but that’s not the case. The line should be:

PrintJob.SetProfileSetting "OpenViewer", "false"

The setting strings are a little inconsistent IMO.


#4

Hi,

it actually makes sense, as the OpenViewer setting applies to all viewers/ file types, not only PDF files. Sorry for the late response, though.

Best regards,

Robin