VBA Code to copy all in pdf and paste it in excel

[himurah182]

Hey guys,

Hope you’re doing okay!

Really need your help on this one.
I need vba code to do the following:
- open pdf based on path that keeps changing (this file keeps changing name because it is a daily file)
- copy everything in there (basically doing a select all + copy all)
- paste it into column A of another sheet in the same excel file that I am using

thank you for attention