View Single Post
 
Old 05-25-2021, 03:38 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Doing a google search to find code which can display PDFs in a vba userform revealed some hits but they appear to not be totally reliable so the performance might be hit or miss on your machines.

If you are using a Application.FileDialog(msoFileDialogFolderPicker) to build a list of PDFs, why don't you use the FilePicker instead and let Windows Preview take care of showing the preview of the PDF? See FileDialogFilters Collection | Microsoft Docs. This way you just return the chosen PDF to the userform (or avoid the userform completely if that was all it was for)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote