+ Reply to Thread
Results 1 to 9 of 9

Save recently open Files in Listbox

  1. #1
    Registered User
    Join Date
    04-03-2019
    Location
    Nigeria
    MS-Off Ver
    2013
    Posts
    60

    Save recently open Files in Listbox

    What code can i use to create a userform that will save all my recently opened files into a listbox?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Save recently open Files in Listbox

    Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    04-03-2019
    Location
    Nigeria
    MS-Off Ver
    2013
    Posts
    60

    Re: Save recently open Files in Listbox

    Quote Originally Posted by YasserKhalil View Post
    Try this
    Please Login or Register  to view this content.
    To what number of files can it stored.
    Also, is there no way to have only the file name while its path is hidden?

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Save recently open Files in Listbox

    You can limit the number of files ..if you need that but I don't know to what number of files it can store
    as for the secnd point try this line instead
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-03-2019
    Location
    Nigeria
    MS-Off Ver
    2013
    Posts
    60

    Re: Save recently open Files in Listbox

    Quote Originally Posted by YasserKhalil View Post
    You can limit the number of files ..if you need that but I don't know to what number of files it can store
    as for the secnd point try this line instead
    Please Login or Register  to view this content.
    I want it even as much as 100.

    By the way, what command button code will I use to open the file using the code?
    Please Login or Register  to view this content.
    Also, how do I go about the coding that will give me the full path (as in comment) of the file name when mouse hover on it?

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Save recently open Files in Listbox

    I didn't get what you mean ..

  7. #7
    Registered User
    Join Date
    04-03-2019
    Location
    Nigeria
    MS-Off Ver
    2013
    Posts
    60

    Re: Save recently open Files in Listbox

    Quote Originally Posted by YasserKhalil View Post
    I didn't get what you mean ..
    Firstly, I want the recentfiles to have 100 files

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Save recently open Files in Listbox

    crossposted: https://www.mrexcel.com/forum/excel-...ml#post5268367

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Save recently open Files in Listbox

    And, BTW
    Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

    For normal conversational replies, try using the QUICK REPLY box below.

+ 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 files from Listbox outside of Excel.
    By kandoo1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2017, 05:36 PM
  2. Populate Listbox with PDF Files and Open File
    By wtfadli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2016, 02:56 AM
  3. Listbox of open files with a common worksheet name
    By cboud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2016, 05:58 PM
  4. [SOLVED] Save/Closed only macro related files and leave unrelated files open in excel?
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2013, 04:17 PM
  5. Listbox open files pdf
    By savyback in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-10-2013, 08:46 AM
  6. Cannot open files in Most Recently Used List
    By Suzan in forum Excel General
    Replies: 3
    Last Post: 07-29-2006, 06:35 PM
  7. Replies: 2
    Last Post: 11-30-2005, 01:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1