PDF to word or excel by vba code

[Nipendra.dhiman]

Hi all,

if i have my 12 standard mark sheet in PDF format and I want to extract required details from this PDF to Word doc...like ..
i need -:
1) date of birth
2) father's name
3) Mother's name
4) Year


is it possible to do with excel vba coding..........

please share your suggestion.

Nipendra

 

[Harry Covair]

Hi Nipendra,
See the Adobe (negative) answer to such a question.
http://forums.adobe.com/thread/1199123
Regards
Harry

 

[Nipendra.dhiman]

Thanks for your reply
so it's not possible.

 

[Debraj]

Logically.. No..

But if you can copy the whole data into Excel / Word.. and fortunately all font are copied, then you can modify it accordingly..

https://groups.google.com/forum/?fromgroups#!topic/excelvbamacros/hPZsy2QyFGM

http://www.siddharthrout.com/2012/0...-form-fields-using-vb-net-from-an-excel-file/

fully depends on the PDF structure.. and luck..

 

[Marc L]

Hi Nipendra,​

​

maybe you can copy data from PDF file and paste it in VBA via the clipboard …​

 

[NARAYANK991]

Hi Nipendra ,

Why reinvent the wheel ?

Just go to :

https://www.pdftoword.com/

I tried it out , and the result is perfect. And it's free.

Narayan

 

[Nipendra.dhiman]

Narayan,

thanks for your reply but I am not looking for a converter I want to do it by vba in excel.

Nipendra

 

[Nipendra.dhiman]

Hi all ,

is it possible with word document if i have all the information in word doc then can i extract it by vba code in excel sheet.

would appricate your comment or reply
Regards
Nipendra

 

[Debraj]

Hi Nipendra,

Check this one..

http://www.exceltip.com/application...-from-excel-using-vba-in-microsoft-excel.html

Hope it helps..

 

[SirJB7]

Hi, Nipendra.dhiman!
Here you'll find a Word handler from Excel VBA:
http://chandoo.org/forum/threads/synonyms-in-status-bar-for-a-selected-word-in-excel.11974
Regards!