Totalnovice
New Member
- Joined
- Mar 30, 2022
- Messages
- 3
- Office Version
- 2013
- Platform
- Windows
Hello,
My problem is probably very simple for you experienced users. So I have file directory, where at regular basis new html-file is added (picrure below). The files have the date in the file name and also as modified date.
What I'd like to do is to have VBA that retrieves the date of the newest file to excel.
Being a novice with VBA I've just googled and tried to find the solution but haven't managed to find the right one yet. So far I've gotten to point where I can get file names imported to excel with VBA (working somewhat alright). Hopefully I can get some help here. Thanks
-Totalnovice
My problem is probably very simple for you experienced users. So I have file directory, where at regular basis new html-file is added (picrure below). The files have the date in the file name and also as modified date.
What I'd like to do is to have VBA that retrieves the date of the newest file to excel.
Being a novice with VBA I've just googled and tried to find the solution but haven't managed to find the right one yet. So far I've gotten to point where I can get file names imported to excel with VBA (working somewhat alright). Hopefully I can get some help here. Thanks
-Totalnovice