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.
17 freelance font une offre moyenne de $284 pour ce travail
I can do this in C# as well as in VBA. Let me know which language you like to have for this? I suggest VBA. Cheers!
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
Hi, Please check feedback. I don't think you can program to selectively import bits of pdf to Excel. I think you have to grab a whole load of it to Sheet 1, then script extraction from there to a sheet for each card a Plus
Data consolidation and automation is one of our key strengths. If no complex parsing of the pdf files is needed we would be the right provider to cover your business needs at the given budget. Some more sophisticated U Plus
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.
Hi I can do it with vba and AppleScript. To solve you problem vba alone is not good enought. I will need sample PDF to test with AppleScript but I'm over 90% confident that this can be done with AppleScript and excel Plus
Dear katonkasno, I intend to do this as follows: (1) Excel workbook on opening asks you to choose a PDF file and opens it through the Adobe Reader (or it can do it automatically if the name of the folder to be sought Plus
Hi, Below is what I would do to automate the whole project. First, as you have mentioned, extract pdf into excel, which can be done very easily. Once the data is in excel, we can loop through all the records a Plus
Hi, Hope you are doing well. I am writing in reply to your project posting. One way to do it is, since your pdf is not a scanned copy, it can easily be converted to word doc through existing software (such as nitr Plus
I have done similar kind of work for my previous [url removed, login to view] your PMB for more details.