+ Reply to Thread
Results 1 to 5 of 5

Sort PDF,XLSX files based on modified date within folders and subfolders

  1. #1
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Sort PDF,XLSX files based on modified date within folders and subfolders

    Hello
    I have files within folders and subfolders in this "C:\Users\Alaa\Desktop\FL"
    the files will be PDF, for all of extensions for EXCEL
    example :"C:\Users\Alaa\Desktop\FL\inv1.xlsx

    "C:\Users\Alaa\Desktop\FL\rett\ACC.XLSM"
    "C:\Users\Alaa\Desktop\FL\rett\files\proc.pdf"
    so I want populate ITEMS in column A (1,2,...) , EXCEL files in column B, column C show modified dates for EXCEL files inside EXCEL FILES sheet , I want populate ITEMS in column A (1,2,...) , PDF files in column B, column C show modified dates for PDF files inside PDF FILES sheet.also hyperlink columns B for both two sheets to open file when click the cell in column B and sort From descending to ascending based on Modified date .
    every time run the macro should replace files names for both two sheets.
    in both two sheets will contain headers in row1(ITEM,FILES NAMES,MODIFIED DATE).
    thanks

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    481

    Re: Sort PDF,XLSX files based on modified date within folders and subfolders

    try this

    Please Login or Register  to view this content.
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Mark Thread as Solved...

  3. #3
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: Sort PDF,XLSX files based on modified date within folders and subfolders

    code is awesome!
    I just need fixing the items are not show number correctly .I would arrange like 1,2,3
    the code will show like 2,1,4,3 !
    also I would ask you , can avoid message when try open PDF file will show message yes to open or no to cancel opening , how can I open directly without show message?
    thanks

  4. #4
    Valued Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    481

    Re: Sort PDF,XLSX files based on modified date within folders and subfolders

    when opening PDF files, this is a system-level behavior controlled by the default PDF viewer or system settings. VBA cannot directly suppress these confirmation messages for PDF files because they are displayed by the OS or the PDF application itself. However, if you're using Adobe Reader, you may be able to configure it to skip such prompts. Let me know if you'd like detailed steps on how to handle this system-level configuration.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: Sort PDF,XLSX files based on modified date within folders and subfolders

    perfect !
    many thanks buddy.

+ 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] Macro to convert all xls files to xlsx with moving the files into new folders
    By nettadecoco in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 12-29-2023, 02:34 PM
  2. how to copy and paste folders / subfolders and files
    By ColemanJames in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2018, 07:32 PM
  3. VBA to Move Folders to Another location Based on Modified date
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2016, 10:02 PM
  4. [SOLVED] Search for files in folders and subfolders
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 08:43 AM
  5. Extracting Image information using Data Modified from Folders & Subfolders
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 01:22 AM
  6. Looping thru files in 2 folders,but the macro picking the files by the modified date
    By XLbeginer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 10:37 AM
  7. [SOLVED] Map/List of folders, subfolders & files
    By Bogdan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2006, 01:10 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