News WordPress Theme

Convert PDF to Excel

Convert PDF to Excel

How to convert PDF files to Excel using sendkeys and microsoft word with VBA. Here’s the complete VBA code: Option Explicit Sub CopyPDFTextToExcel() Dim varRetVal As Variant, PathToPDF As String, strCommand As String Sheet1.Cells.ClearContents Sheet1.Range(“A1”).Activate ‘PathToPDF = “C:UserstakyarDesktoptest1.pdf” PathToPDF = “C:exceltrainingvideosAboutWindowsAPIs.pdf” strCommand = “C:Program Files (x86)AdobeAcrobat Reader DCReaderAcroRd32.exe ” & PathToPDF ‘ Use Shell Function to open Adobe Acrobat…

Read More