Pdf to excel

[KUYJS]

Hi

I get invoice on pdf in image format and to do my work i need all those figures of these invoices on excel. Is there a way to do this using excel vba.

I heard about one note whixh can actually help but have no idea how to copy pdf content to one note and then one note content to excel.

Please suggest if it's doable?

Thanks,
Tarun

 

[Logit]

This will get you started ... at least.

You'll need to download the free Adobe Reader from the Adobe website. Verify the location of the reader on your machine and make the necessary edit to the
path in the macro code.

Option Explicit


Sub StartAdobe()
Dim AdobeApp As String
Dim AdobeFile As String
Dim StartAdobe
Dim intChoice As Integer
Dim strPath As String


'only allow the user to select one file
Application.FileDialog(msoFileDialogOpen).AllowMultiSelect = False


'make the file dialog visible to the user
intChoice = Application.FileDialog(msoFileDialogOpen).Show


'determine what choice the user made
    If intChoice <> 0 Then
    
        'get the file path selected by the user
        AdobeFile = Application.FileDialog(msoFileDialogOpen).SelectedItems(1)
        
        'verify location of Adobe Reader on your machine.
        AdobeApp = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"
         
        StartAdobe = Shell("" & AdobeApp & " " & AdobeFile & "", 1)
         
        Application.Wait (Now + TimeValue("0:00:01"))
        
        SendKeys ("^a")
        SendKeys ("^c")
         
        Application.Wait (Now + TimeValue("0:00:01"))
        
        SendKeys ("%fx")
        
        AppActivate "Microsoft Excel"
        
        ThisWorkbook.Activate
        
        Sheets(1).Activate
        
        Range("A1").Activate
        
        SendKeys ("^v")
    
    End If


End Sub

 

[KUYJS]

This is not converting image to text. My invoice is image of invoice in pdf

 

[Logit]

.
My apologies. I misunderstood the format of the PDF file.

Look at this link : https://www.quora.com/How-do-I-convert-jpeg-image-data-to-Excel-VBA

And this link : https://www.cisdem.com/resource/convert-image-to-excel.html