Code:
Private Sub CommandButton1_Click()
Dim pdfFile As Variant
Dim selPDF As Variant
pdfFile = Application.GetSaveAsFilename(InitialFileName:=ThisWorkbook.ActiveSheet.name, FileFilter:="PDF Files (*.pdf), *.pdf")
pdfPath.Value = pdfFile
pdfPath.Locked = True
End Sub
Well, this is a piece of code which contains the path to pdf file, but all the rest is to do.
I've watched a few videos on YT regarding scraping data from pdf, however none of them doesn't present a simple example.
The idea is to reflect "crtl+F" in pdf using vba. In a user form I enter a single word or a character which should be found in pdf file and pasted into Excel.
If You know how to do it, I am looking forward to hearing from You.
Last edited: