Macros (attached) task is to open today's file from a folder, copy its contents in Excel sheet and close it.
The files are saved by the application with a strange criteria. Random saves files in formats "d.m.yyyy" or "d.mm.yyyy" or "dd.m.yyyy" or "dd.mm.yyyy" (like "7.5.2016-K.xml" or "7.05.2016-K.xml" or "07.5.2016-K.xml" or "07.05.2016-K.xml"), and I can not affect it.
The macro works perfectly until a date is in ONE of the format above.
Is there a possibility to declare "myToday = Format(Date, "dd.m.yyyy")" with multiple criteria which will include all date formats above, so the macro identifies the file regardless of the date format.
Thanks
Bookmarks