Modification required in VBA PDF to excel conversion-

[Zahid0111]

The attached excel file converts PDF file to excel. But i need some modification with it, At address A2 path of PDF file is entered and at B2 type is selected like .xlsx. When convert button is pressed it converts PDF to excel at same location.
Now what i want with this code to be modified is that:
1) It should ask from user to select PDF file(by using application.open method) and by default it should convert to xlsx format.
2) Sheet should be named as "Farmer History" to which data is copied
3) Headings to be ignored during copy

Due to some error, i am unable to post VBA CODE here, Kindly check the attached Convert PDF Files Into Different Format.xlsm excel file

I have asked this question here too:https://www.mrexcel.com/board/thread...rsion.1130694/