+ Reply to Thread
Results 1 to 3 of 3

Open pdf file from filename in listbox

  1. #1
    Registered User
    Join Date
    09-09-2021
    Location
    Austria
    MS-Off Ver
    Office2016
    Posts
    2

    Question Open pdf file from filename in listbox

    Hi all,
    I am new here, but i need really your help.

    I created a sheet with lots of filenames from pdf files in a table. All the pdf files are saved in the same folder on a network drive or on the windows machine. Now i created a userform with textbox and listbox, loading columns with rowsource to the listbox, filtered by the keyword in the textbox. This works very well.

    But now the problem: I need to open the pdf files with associated pdf viewer by doubleclick on the filtered file in the listbox. Should be possible by adobe reader on some windows machine.

    Could you please help me with this?
    Thanks alot
    Attached Files Attached Files

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Open pdf file from filename in listbox

    See attached

    You will have to set the filepath to where the documents are kept
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by nigelog; 09-09-2021 at 10:47 AM.

  3. #3
    Registered User
    Join Date
    09-09-2021
    Location
    Austria
    MS-Off Ver
    Office2016
    Posts
    2

    Re: Open pdf file from filename in listbox

    Hi, nigelog, thanks for your answer, it works fine. Thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Open file via VBA and paste filename in original file
    By kammend in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2016, 09:29 AM
  2. Open file with partial filename
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2016, 06:48 PM
  3. [SOLVED] open file with cell value as filename
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2014, 08:49 AM
  4. Open a file with varying filename
    By gototcm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2014, 11:24 AM
  5. Replies: 4
    Last Post: 10-23-2013, 12:54 AM
  6. Macro: Open file but the filename changes
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2013, 06:36 AM
  7. [SOLVED] Open file with a specific string in the filename
    By vikas.mehta80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2012, 05:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1