+ Reply to Thread
Results 1 to 2 of 2

How to browse a excel file whose file name will keep on change?

  1. #1
    Registered User
    Join Date
    02-06-2018
    Location
    INDIA
    MS-Off Ver
    2016
    Posts
    6

    How to browse a excel file whose file name will keep on change?

    Hello,
    I am working on a macro , which lets user to select his preferred excel file whose file name is dynamic and changes from time to time. How to open the file using vba code and once opened i need to get the opened excel file name also .
    please help me on this.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How to browse a excel file whose file name will keep on change?

    which lets user to select his preferred excel file whose file name is dynamic and changes from time to time
    how are you doing this? or is this the question?

    https://analystcave.com/vba-applicat...g-select-file/

    this link provides several examples of which you can copy off
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Browse for a file edit the file then attach it to an email
    By Bobbbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2016, 11:50 PM
  2. Macro Required for attaching a file through Browse option in excel file
    By vikash200418 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2015, 12:38 AM
  3. How to browse & Attach a file to a userform in Excel?
    By rajat518 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 05:04 AM
  4. [SOLVED] Macro to browse for an excel file in a specfic directory
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2012, 12:45 PM
  5. Browse for file name code? (Excel 2002 VBA)
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2006, 08:45 AM
  6. File Browse Function (Open dialog box for choosing file)
    By b-123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2005, 06:05 PM
  7. Need to browse 100's of file TITLES in Excel 2000
    By jeffbro27707 in forum Excel General
    Replies: 3
    Last Post: 05-02-2005, 05:06 PM

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