Closed Thread
Results 1 to 5 of 5

Open PDF file knowing it's directory and only part of the unique file name.

  1. 10-24-2023, 01:59 AM #1
    Travisty123
    Travisty123 is offline
    Registered User
    Join Date
    10-16-2023
    Location
    Australia
    MS-Off Ver
    Office 2016
    Posts
    16

    Open PDF file knowing it's directory and only part of the unique file name.

    Hi folks,

    I'm looking for a formula that will open PDF file knowing it's directory and only part of the unique file name. I'm hoping there's some sort of wildcard reference that can assist in doing what I need.

    The data for the file name will be located in cell D4 and the data will contain "Q184645"

    Located in the directory "C:\TESTQUOTES" is the file with the full name "Q184645_07_09_15_23-100622709.pdf"
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-24-2023, 02:02 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,246

    Re: Open PDF file knowing it's directory and only part of the unique file name.

    If you are wanting Excel to open a file for you, you'll need VBA.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-24-2023, 02:18 AM #3
    Travisty123
    Travisty123 is offline
    Registered User
    Join Date
    10-16-2023
    Location
    Australia
    MS-Off Ver
    Office 2016
    Posts
    16

    Re: Open PDF file knowing it's directory and only part of the unique file name.

    Thank you. Happy to close off thread now as I've posted in the VBA sub forum.
    Reply With QuoteRegister To Reply
  4. 10-24-2023, 02:23 AM #4
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,006

    Re: Open PDF file knowing it's directory and only part of the unique file name.

    Thread closed. Continue here:

    https://www.excelforum.com/excel-pro...file-name.html
    Reply With QuoteRegister To Reply
  5. 10-24-2023, 02:34 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,246

    Re: Open PDF file knowing it's directory and only part of the unique file name.

    Quote Originally Posted by Travisty123 View Post
    Thank you. Happy to close off thread now as I've posted in the VBA sub forum.
    Please don't do this again - you should have asked to have the thread moved. Please bear this in mind in future.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open file without knowing file location
    By cc2019 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2019, 02:04 PM
  2. [SOLVED] how do i open up a file knowing the first part of the filename in excel using vba
    By BrianTFC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-22-2019, 03:31 PM
  3. Open File in Excel each Time file is Saved In Another Directory (Data From Text Linking)
    By rjj920 in forum Excel General
    Replies: 0
    Last Post: 02-09-2016, 06:14 PM
  4. Open File in Directory with a Part of Filename as String
    By paesu57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2014, 06:27 AM
  5. [SOLVED] Open excel file by providing a part of file name through inputbox
    By sbabu16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2014, 05:30 AM
  6. [SOLVED] Extract file path from sheet location - then open another file in the same directory
    By mick86 in forum Excel General
    Replies: 5
    Last Post: 09-29-2012, 12:40 PM
  7. Find File in Directory(s) and Open Folder highlighting file
    By cpadude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2010, 05:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1