Hey everyone,
I am needing my bot to be able to open a daily file with every file having this type of naming convention: "Filename.YearZeroMonthZeroDay.RandomNumbers" so something like this: ExampleFileName.20200306.8975421
However, because of the random numbers at the end the bot cannot open that daily file. I have variablized the filename like this: Name.m*YEAR]A*MONTH_ZERO-FILLED]E*DAY_ZERO-FILLED]. I have tried wildcarding the end with * but the File Exist function does not work with wildcards. Is there a way to bypass this or maybe another method i should try? Thanks