Hello,
I'm looking to loop through all the pdf's in my folder. I need to copy all data in the pdfs and paste it into my workbook(sheet1) where i will call other macros to process the data. Once the data has been processed i will clear Sheet 1 with another macro before returning to this original one. I've seen threads using the sendkeys action but im unsure on how to use it in the overall code.
After opening PDF
SendKeys ("^a")
SendKeys ("^c")
In excel sheet
Range("A1").Activate
SendKeys ("^v")
Any Help would be greatly appreciated.
Thank you!
I'm looking to loop through all the pdf's in my folder. I need to copy all data in the pdfs and paste it into my workbook(sheet1) where i will call other macros to process the data. Once the data has been processed i will clear Sheet 1 with another macro before returning to this original one. I've seen threads using the sendkeys action but im unsure on how to use it in the overall code.
After opening PDF
SendKeys ("^a")
SendKeys ("^c")
In excel sheet
Range("A1").Activate
SendKeys ("^v")
Any Help would be greatly appreciated.
Thank you!