Hi John,
Thank you for your reply. I am not looking for someone to do this for me (although that would be very convenient), but I am looking for someone who can help me with (a part of) the code for macro express.
The process that you described is more or less correct. However, I want to automate as much as possible.
I will probably be able to create the simple parts of the code (ie opening and closing of files, etc.). The part of the code where there is a choice (if statement) is much more of a chalenge to me.
Any help with the code is still more than welcome!
Regs,
Vince
P.S. I am now also looking at converting PDF into xls, which should make it somewhat easier.