VBA Code to Extract Highlighted Text only from PDF file to Excel

[krishnaoptif]

Hi expert please provide VBA code to extract only highlighted text from PDF file to excel file..

I am thinking to setup file picker in to excel to pick pdf file and pick highlighted text from pdf to excel file column 1.

Please find pdf file :
https://www.dropbox.com/s/pwnxrhwvdifqtg7/download.pdf

Thanks in advance.

 

[sijpie]

This is not a very simple task. You will have to control a non-Excel file using file handles, and you will have to control the clipboard, which is also not too trivial.

I would suggest to start off to read about how to use the clipboard in VBA.
Then make a macro that only pastes what is in the clipboard to your spreadsheet. (so selecting the file and highlighting the text and pressing Ctrl-V to copy is still manual)

You might find that this will give you sufficient automation to get you going.