Manipulating Pdf and Txt files using VBA

Hey all,

I have been searching the forums for ways to manipulate pdf and txt files using excel vba, but to no avail. If anyone could kindly help me with my situation below, it would be greatly appreciated.

I have a folder that contains 20 pdf and txt files. In these files, there is a common word, 'revenue'. After the word revenue, there are revenue figures. (e.g. Revenue : 50,000) I need to copy these revenue figures (50,000) and list them in an excel sheet, according to the alphabetical order of the pdf and txt files in the folder.

I have some limitations - I am unable to convert these pdf and txt files to excel format. If possible, the script should be able to access these files in their original format so that I do not need to access these files individually to get their revenue figures.

Any form of help is welcome!

bump bump bump