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()
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()