PDF to Excel - VBA

kaylan

New Member
Joined
Aug 19, 2019
Messages
9
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
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,126,928
Messages
5,621,639
Members
415,849
Latest member
PhoenixRising2015

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top