PDF to Excel macro, script
This project was awarded to ShiaFirst for $250 USD.Get free quotes for a project like this
Project Budget$250 - $750 USD
We have a bank statement in PDF format that Morgan Stanley provides monthly. There are a few pages in this document that have about 10 different Credit Card statements/transactions that we need to bring into CSV (Excel) in a standardized format.
We will need this to be automated because it will happen monthly.
Ideally, the script will be able to find the first credit card, and extract the transactions into an Excel file and save that file to disk with the last 4 digits of the CC as filename. For each CC statement found within the PDF, a new Excel file will be created.
There are multiple credit cards per page, in 2-column format. See attachment.
Once you can give it to us in separate file, we will handle what we need (bringing that into Access to convert it into IIF for Quickbooks).
** Please explain your expertise, and how you intend to do this. I'm a programmer, so you can talk technical.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online