In Progress

PDF to Excel macro, script

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.

Skills: Data Processing, Excel, PDF, Visual Basic for Apps

See more: script pdf excel, excel macro script pdf, what do i give to a programmer, processing find programmer, need of excel programmer, morgan stanley, morgan & morgan, m format in excel, how to find programmer, how to find a programmer for excel, how to find an excel programmer, how to find a c++ programmer, how can i find a programmer, find an excel programmer, excel macro how to, pdf csv script, excel macro pdf, pdf excel macro, excel expertise, excel macro script, macro script excel, new excel, morgan m, credit card csv, convert pdf to excel file

About the Employer:
( 8 reviews ) Coatesville, United States

Project ID: #1657473

17 freelancers are bidding on average $284 for this job

ShiaFirst

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!

$250 USD in 2 days
(32 Reviews)
6.4
chriskerpini

More than 10 years experience in Excel-VBA. Please see PM for more details.

$250 USD in 3 days
(36 Reviews)
5.5
ineedWorkJob

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)

$250 USD in 2 days
(35 Reviews)
5.3
MDavidCrompton

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 More

$325 USD in 7 days
(33 Reviews)
5.2
Krusche

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 More

$250 USD in 5 days
(21 Reviews)
5.2
expertatwork

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.

$250 USD in 4 days
(69 Reviews)
5.1
northwolves

Ready to [url removed, login to view] moredetails,please.

$250 USD in 2 days
(46 Reviews)
5.0
Nhcuong

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 More

$250 USD in 7 days
(22 Reviews)
4.9
masterdesignbd

Hello Sir, I am interested on this job. Please check PM for details. Thanks.

$300 USD in 10 days
(2 Reviews)
0.0
dwane

Hello Sir I am ready and willing to work for you.

$250 USD in 10 days
(0 Reviews)
0.0
SaifMorshed

You can me. I must submit you work in time i have Experience in Early I can show prof

$255 USD in 2 days
(0 Reviews)
0.0
KRKans

Hi Project sounds good to me. Refer to your PM.

$250 USD in 3 days
(0 Reviews)
0.0
SergeySh

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 More

$250 USD in 2 days
(0 Reviews)
0.0
chSoft

Please check your PMB.

$250 USD in 5 days
(0 Reviews)
1.2
allansmarty

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 More

$250 USD in 5 days
(0 Reviews)
0.0
freelancerkks

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 More

$250 USD in 5 days
(0 Reviews)
0.0
kunalTecho

I have done similar kind of work for my previous [url removed, login to view] your PMB for more details.

$690 USD in 15 days
(0 Reviews)
0.0