PDF address list to Excel using VBA and probably iFilter -- 2
$30-250 USD
Cancelled
Posted about 10 years ago
$30-250 USD
Paid on delivery
I need a macro created that will bring in an address list from a PDF into an Excel spreadsheet and saved to a CSV. The data will be reordered into correct rows and columns. The columns need to be called by column header (not by column number) and each successive address should go on successive rows. This is shown in the attached Excel file in the way I thought about doing it step-by-step.
The spreadsheet then needs to save as a CSV with the same name as the sample PDF. This should be able to run through a folder of PDFs opening, moving the data, saving as the title of the PDF file, then going on to the next one.
To get the PDF file name, an iFilter implementation may be best. If you do not know iFilter, but have another good way to do this all, I'm open to suggestions. Likely formulas and possibly a VBA loop will move the data around rather easily.
Ideally the best candidate will be available to walk me through the macro so I can understand it. I'm fairly familiar with VBA and formulas, but not with iFilter.
I need this as soon as possible, no later than Monday, March 31. I expect this will only take about 3-4 hours to write and another hour to teach me and answer my questions.