Can a PDF File's Protected View be Removed with VBA Code
I have some VBA Code in MS Access that grabs a PDF from an email in Outlook. When I open these PDFs they show that they are in "Protected View" mode. Next to this message is a "Enable All Features" button that removes the protection.
My VBA code loops through the PDF document and grabs the text from each field and then puts it in a table in Access. Because the PDFs are protected, it's unable to grab any of the text from the PDF.
Is there a way with VBA Code to remove the "Protected View" mode from the PDFs once it is open, and prior to my VBA Code running?
Here is my VBA code:
Function GetFileText(strFilePath As String) As String'IAC objectsDim gPdDoc As Acrobat.CAcroPDDocDim gAvDoc As Acrobat.CAcroAVDoc'variables'Dim gPDFPath As StringDim sName As StringDim lNum As Integer'Initialize Acrobat by creating App objectSet gApp = CreateObject("AcroExch.App")'Set AVDoc object'gAvDoc = gApp.GetActiveDocSet gAvDoc = CreateObject("AcroExch.AVDoc")' open the PDFIf gAvDoc.Open(strFilePath, "") Then gApp.Show 'Set PDDoc object and get some data Set gPdDoc = gAvDoc.GetPDDoc lNum = gPdDoc.GetNumPages sName = gPdDoc.GetFileName GetFileText = Acro_GetPageText(strFilePath, gPdDoc, gAvDoc)End IfEnd Function
I noticed that the software in your post is available for download. Only problem, our company doesn't allow us to download anything.
I've also got the IT people here at work looking into why it isn't working now, because it wasn't an issue prior to upgrading to Windows 10 and MS Access 2016. These PDF documents were protected before also, but it worked.
Thanks,
gdunn59
John Tsioumpris
Trying to bypass limitations without using extra tools is near impossible
If it could, then "protected" would not mean much...
;-)
But lets see what other experts may suggest.