Hello,
I have a project where I need to copy and paste the data from a PDF file to my Excel project. From my searches, I know that using SENDKEYS() and SHELL() seem to be the common/best solution, but these are using defined file paths on all examples that I've seen. In my case, the name of the PDF is going to change each time and will not be saved. I previously had posted this question so I think modifying the solution on there could allow me to reference the unsaved PDF file. Is that correct, and if so how would the SENDKEYS() and SHELL() portions of the code need to be structured?
I know from manually copying/pasting the PDF into my Excel file that the data comes through as a long string on each line; that is okay, I already wrote the code to correct for that. Just need to figure out how to automate the copying/pasting portion, as my end user is really not great with technology.
Thank you!
-Kaylan
I have a project where I need to copy and paste the data from a PDF file to my Excel project. From my searches, I know that using SENDKEYS() and SHELL() seem to be the common/best solution, but these are using defined file paths on all examples that I've seen. In my case, the name of the PDF is going to change each time and will not be saved. I previously had posted this question so I think modifying the solution on there could allow me to reference the unsaved PDF file. Is that correct, and if so how would the SENDKEYS() and SHELL() portions of the code need to be structured?
I know from manually copying/pasting the PDF into my Excel file that the data comes through as a long string on each line; that is okay, I already wrote the code to correct for that. Just need to figure out how to automate the copying/pasting portion, as my end user is really not great with technology.
Thank you!
-Kaylan