+ Reply to Thread
Results 1 to 3 of 3

Macro to highlight last file in folder selected

  1. #1
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Macro to highlight last file in folder selected

    I have the following code , which allows me to select various files and the code works perfectly


    I would , however, like the code to be amended so that after the first file is selected, then that file in the folder is to be highlighted (or other means ) , so that the user can see which file was last selected. Once the next file is selected, then that file to be highlighted etc


    Your assistance in this regard is most appreciated

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Macro to highlight last file in folder selected

    How about creating a message string that grows with every file opened and displaying that before attempting to open a new file?

    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Re: Macro to highlight last file in folder selected

    Thanks for the help, much appreciated

+ 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. Error in mailing of a file as attachment in my selected folder path
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2017, 07:33 AM
  2. [Path location and Document macro]Require File , Folder and sub-folder path creator macro
    By Nitish Shrestha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 02:23 AM
  3. Read File.Paths in selected Folder + open relevant files
    By PatrickMiller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2017, 08:51 AM
  4. [SOLVED] vba get the folder of a file selected from the msofiledialogfilepicker
    By simarui in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2015, 03:06 PM
  5. [SOLVED] Display the link of the file from fixed folder when the file is selected from drop down
    By vignesh805 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2013, 06:38 AM
  6. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 AM
  7. macro to move from file to file, folder to folder
    By davegb in forum Excel General
    Replies: 0
    Last Post: 01-21-2005, 04: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