I've got the following task:
In order to check bookings, I created the macro, that does everything I need it to do.
The tables I run the macro on, always have the same structure. My problem is with the file names - they always have a time stamp in their name, from when they're downloaded.
I'd like to automate the macro, so that they can run on any file without having to rename the files everytime.
The file names look like this:
The macro is tied to the last 4 letters of the file name, which is sort of the identification of what's in the file.
Hope this was understandable, grateful for any help.
Last seen: 4 weeks 18 hours ago
Joined: 08/11/2020 - 03:30