Just Two Questions on PDF Files

SamDsouza · #1 05-26-2021, 11:21 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PPT VBA Questions	davidmorse	PowerPoint	0	03-06-2018 09:35 PM
Questions	S_jt_C	Word	1	12-05-2015 04:35 PM
Converting 'comments' into text files (2 questions)	Paul Lance	Word	1	04-29-2013 06:00 PM
Few questions...needs some help!	Wolf.Stalker	Outlook	1	02-21-2012 09:15 PM
onenote offline cache files questions	mdc8989	OneNote	1	02-04-2011 11:47 AM