Macro to convert PDF bank statement to Excel

[irfananeeza]

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,

 

[Michael M]

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

EXCELGAARD → PDF2XL ()

Microsoft Excel dedicated website

www.excelgaard.dk

 

[irfananeeza]

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.