Avatar of gdunn59
gdunn59
 asked on

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 objects
Dim gPdDoc As Acrobat.CAcroPDDoc
Dim gAvDoc As Acrobat.CAcroAVDoc

'variables
'Dim gPDFPath As String
Dim sName As String
Dim lNum As Integer

'Initialize Acrobat by creating App object
Set gApp = CreateObject("AcroExch.App")

'Set AVDoc object
'gAvDoc = gApp.GetActiveDoc
Set gAvDoc = CreateObject("AcroExch.AVDoc")

' open the PDF
If 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 If

End Function

Open in new window

Thanks,
gdunn59
Adobe FlashVBAMicrosoft Access

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
Jeffrey Coachman

I don't think VBA can manipulate a PDF to that level...

If it could, then "protected" would not mean much...
;-)

But lets see what other experts may suggest.
gdunn59

ASKER
Jeffrey Coachman,

That's what I was wondering.

Thanks!
Jeffrey Coachman

oK, ...lets see if another Expert may have a suggestion
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gdunn59

ASKER
John,

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