Macro to convert PDF bank statement to Excel

irfananeeza

Active Member
Joined
Feb 15, 2008
Messages
339
Office Version
  1. 2010
Mr excel experts,

I have a bank statement in PDF format. It is split into two parts.
PART1: part 1 has Date, Description, Debit, Credit, & Balance columns. I need a macro to convert PDF file columns to excel.
PART2: part 2 has cheque images of the front and back of the cheques at the end of the bank statement. I want macro to pull those images on the excel sheet as well.

Thanks,
 
Not easily done without a PDF converter....but have a look at this from Dan Elgaard. Be warned though it's not a simple excercise

 
Upvote 0
Thank Michael, I appreciate your help. I have to admit I am not macro savvy, so the macro code looks daunting. I will go through detailed comments to apply this macro for my task. I will let you know in case of any error message pop up. Thanks.
 
Upvote 0

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