macro get the files names based on modified date & current month

tubrak

Board Regular
Joined
May 30, 2021
Messages
68
Office Version
  1. 2019
Platform
  1. Windows
hi I search macro it create the sheet based on current year in this case 2021 year and creat the headers . their names based on months JAN,FEB up to DEC and show all of files are modified date for any file based on current month for instance if I open file in this month and closed it will modified based on current month JAN and so on for the rest of months , if I open the file in FEB and I have ever opened file in JAN then delete from list of JAN month and move to FEB month and when finish 2021 and enter next year 2022 then should create another sheet is 2022 YEAR and create the headers and get list the files with considering should show hyperlink for the files name in second column for each month to open the file . the macro should run from the first sheet then it will create the sheets.

last thing this is my directory "D:\files" contains many folders and all of the folders contain many differnt extensions files .
this should be when run the macro
4.xlsx
ABCDEFGHIJKLM
1JANFEBMAR
2ITEMFILE NAMEMODIFIED DATE FILEITEMFILE NAMEMODIFIED DATE FILEITEMFILE NAMEMODIFIED DATE FILE
31AA1.PDF01/01/2021 03:10:22AM1REPORT1.XLS02/01/2021 01:10:22AM
42AS.JPG01/02/2021 02:20:02AM2REPORT12.XLSM02/02/2021 01:20:02AM
53AM.DOCX01/03/2021 01:30:02AM3LL.XLSX02/03/2021 02:30:02AM
6
7
8
9
2021 YEAR


thanks in advance
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,143,637
Messages
5,719,969
Members
422,252
Latest member
wannabegeek1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top