Quote:
SamD
I'm having trouble understanding your English.
|
Was Completely confussed
Quote:
If you open the chosen PDF as editable in Word then the pagination and layout is likely to be different to what was in the PDF. Converting a PDF into Word format is rarely perfect.
To convert the PDF to Word and open the file you could use
Documents.Open FileName:=xFdItem, Format:=wdOpenFormatAuto
|
OK
Quote:
To answer your second question, I need to understand what you are actually trying to do. Your initial code was for a vba userform and you were asking how to select a file from a list in that userform. The code I have pointed you towards provides an alternative method to view and select a file. Potentially this code completely removes the need for the userform - but I don't know what else you needed the userform to do. If the only reason you needed the userform was to give the user a way to select a file then you no longer need the userform.
However, if you are doing OTHER things with the userform then your filepicker might store the selected filename in a text control on the userform and then when the user closes the userform, the actual file conversion/open should happen.
|
Fine Now i've understood your point and probably What i was actually trying to do seems NOT practical or Rather NOT POSSIBLE for desired results that Userform to do.
Sir Andrew
In the following thread from MrExcel all the references are for Adobe Acrobat.....
and i could not execute the same and see the desired result specifically in MS-Excel because Nothing of Adobe is installed
MrExcel Thread
How to open & select PDF data and paste it in excel file using VBA code ? | MrExcel Message Board
Could you help me for what tool>References that i need to tick for MS-Edge So that i could explore on MS-Word and if required in MS-Excel
BTW are Tool>References same in MS-Word and MS-Excel
SamD