Opening a password protected pdf.

[Rasberry]

When I get to the line: pdfReader.Open(pdfFile,pdfPassword), it says wrong syntax and won't advance. Any suggestions?



Dim pdfFile As String
Dim pdfPassword As String

'Set the path to the PDF file
pdfFile = "I:\Securities\Cash Commitments & Projection\Downloads\PGPMessage_2023802"

'Set the password for the PDF file
pdfPassword = "Pain2023"

'Create an object variable
Dim pdfReader As Object

'Set the object variable to a new instance of the AcroPDF.PDFReader object
Set pdfReader = CreateObject("AcroPDF.PDFReader")

'Open the PDF file with the password
pdfReader.Open(pdfFile, pdfPassword)

'Do something with the PDF file

'Close the PDF file
pdfReader.Close()

 

[Skyybot]

Try this:

Dim pdfFile As String
Dim pdfPassword As String

'Set the path to the PDF file
pdfFile = "I:\Securities\Cash Commitments & Projection\Downloads\PGPMessage_2023802"

'Set the password for the PDF file
pdfPassword = "Pain2023"

'Create an object variable
Dim pdfReader As Object

'Set the object variable to a new instance of the AcroPDF.PDFReader object
Set pdfReader = CreateObject("AcroPDF.PDFReader")

'Open the PDF file with the password
pdfReader.Open(pdfFile, Password:= pdfPassword)

'Do something with the PDF file

'Close the PDF file
pdfReader.Close()

 

[Rasberry]

Try this:

Dim pdfFile As String
Dim pdfPassword As String

'Set the path to the PDF file
pdfFile = "I:\Securities\Cash Commitments & Projection\Downloads\PGPMessage_2023802"

'Set the password for the PDF file
pdfPassword = "Pain2023"

'Create an object variable
Dim pdfReader As Object

'Set the object variable to a new instance of the AcroPDF.PDFReader object
Set pdfReader = CreateObject("AcroPDF.PDFReader")

'Open the PDF file with the password
pdfReader.Open(pdfFile, Password:= pdfPassword)

'Do something with the PDF file

'Close the PDF file
pdfReader.Close()

Thank you so much. That syntax did not work either. I am working in VBA, if that makes a difference.