Sub pdf2exl() Dim starDir As String, PDFPath As String, READERPath As String 'Starting path for user selecting pdf files startDir = "C:\testing\" ChDir startDir PDFPath = Application.GetOpenFilename(filefilter:="PDF file (*.pdf), *.pdf") If UCase(PDFPath) = "FALSE" Then Exit Sub End If 'Please change to your own Adobe Reader installation path READERPath = "C:\Program Files (x86)\Adobe\Acrobat Reader\AcroRd32.exe " Shell READERPath & PDFPath, vbNormalFocus: DoEvents Application.Wait Now + TimeValue("00:00:2") SendKeys "^a", True Application.Wait Now + TimeValue("00:00:2") SendKeys "^c" Application.Wait Now + TimeValue("00:00:2") SendKeys "%{F4}", True Application.Wait Now + TimeValue("00:00:2") 'Paste in Sheet1 Worksheets("Sheet1").Activate Sheet1.Cells.Clear Sheet1.Paste Sheet1.Range("A1") End Sub
2016年6月10日 星期五
[VBA] A macro for copying the text from pdf to excel with Adobe Reader ONLY
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言