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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,632
Latest member
jladair

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
Back
Top