PDF to Excel/CSV

[da_phat]

hi,
i was just wondering if is there any possible ways on converting multiple pdf files into a template of excel/csv format.Please guide me here.thanks

[stanl]

It is possible. If you have full-blown Acrobat you can write VBA code for the OLE interface. With the reader you can use Sendkeys to copy/paste through the Clipboard.

That being said, whether or no the data will parse to csv will depend on how it is set up in the pdf. Posting an example pdf is the best way to answer that.

.02 Stan

[da_phat]

hi stanl.Thanks for replying.Here i attached the sample pdf file.Take it for example, i would like to extract certain field such as "Order Data", "Customer Name","Addres" and "Product Code".Is it possilble that is implemented in VBA?Thanks

[da_phat]

hi stanl.Thanks for replying.Here i attached the sample pdf file.Take it for example, i would like to extract certain field such as "Order Data", "Customer Name","Addres" and "Product Code".Is it possilble that is implemented in VBA?Thanks