Macro to Converting PDF file into Excel

[guykou2001]

Hello,

please can anyone help me with a macro formula to convert a PDF file into Excel with no modification.

this is an example how the copy and paste on a word format look like


First Name Last Name Job Title Company Name Registration Type
Les Funtleyder Portfolio Manager E Sqaured Asset Manager/Hedge Fund
Henry Maslowski VP A C Binder Corp Asset Manager/Hedge Fund
Nina Xu Chartered Financial Analyst Able Capital Inc Asset Manager/Hedge Fund
Peter Barber Partner Aceras Life Sciences LLC Asset Manager/Hedge Fund
Irene Grinevich Senior Analyst AFUND Asset Manager/Hedge Fund
Pascal Nigen Managing Partner Alpha Bronze Asset Manager/Hedge Fund
Sena Lund Analyst Ardana Capital Asset Manager/Hedge Fund
Byron Collier Managing Member Artemis Capital Group, LLC Asset Manager/Hedge Fund
Andreas Argyrides Managing Partner Asclepia Capital Asset Manager/Hedge Fund
Marc Dlugoff CEO Atlantic Capital Asset Manager/Hedge Fund
Raj Mehra PM Auriga Capital Asset Manager/Hedge Fund
Glen Losev Analyst Auriga Capital Management Asset Manager/Hedge Fund
William Wolkstein Analyst Auriga Capital Management Asset Manager/Hedge Fund
Peter Fry Chief Investment Officer BCF Capital Asset Manager/Hedge Fund
John MOHR Partner BioAsset Advisors Asset Manager/Hedge Fund
Zack Fink Portfolio Manager Bioterp Partners Asset Manager/Hedge Fund
Kristen Kosofsky Managing Member Capital Solutions Asset Manager/Hedge Fund
Robert Smith Security Analyst; Portfolio Manager Center for Performance Investing Asset Manager/Hedge Fund
Jeff paley portfolio manager crimson biomedical Asset Manager/Hedge Fund
James Cronin Managind Director Crossroads Capital Management Asset Manager/Hedge Fund
linda gutman managing partner crown point group Asset Manager/Hedge Fund
Ellen Leventhal Vp- Portfolio Manager Delta Capital Management Asset Manager/Hedge Fund
Kira Sheinerman CEO DiamiR Asset Manager/Hedge Fund
Ed Ilyadzhanov Principal Manager E Squared Asset Asset Manager/Hedge Fund
Trammy Lai Healthcare Intern E Squared Asset Asset Manager/Hedge Fund
Jeff Comisarow Portfolio Manager Early Harvest Fund Asset Manager/Hedge Fund
Patrick Moriarty Senior Analyst Early Harvest Fund Asset Manager/Hedge Fund
Oleg Nodelman Managing Director EcoR1 Capital Asset Manager/Hedge Fund
Dave Mcnichol Assist Dir ECommerce Emblemhealth Asset Manager/Hedge Fund
Andrew Vaino Analyst Eudysmic Capital Asset Manager/Hedge Fund
Frank Bamberger President F,B .Asset Management Asset Manager/Hedge Fund
Samir Farghaly Chairman and CEO FC Capital Mangement Asset Manager/Hedge Fund
Zhang Jason Founder Fengling, LLC Asset Manager/Hedge Fund
Gabor Baumann President Galaxiom/Noveltek Capital Group

I would like it to be like the below on excel.

First Name Last Name Job Title Company Name Registration Type

Les Funtleyder Portfolio Manager E Sqaured Asset Manager/Hedge Fund


Many thanks,

 

[Macropod]

That's not going to happen unless the PDF's structure is conducive the copy/paste into Excel while maintaining Excel's column structure. Probably your best option is to use an OCR package that can read the layout and export the content to a Word table. From there it's a trivial exercise to export to Excel. Better still would be to obtain the data from the source; after all, something had to be used to produce the PDF - probably Word or Excel...