Hello!

I am new here so I appreciate you taking time to assist and I'm sorry if the formatting isn't proper.

So the problem I have is there are a few checks I am doing to see if I can use a function based off a VBA that can check if there is a file in a folder that exists and matches today's date. Currently, I'm using FileExist and can use that since I can produce the majority of the names of the files automatically downloaded. However, all of these automatically downloaded files' names may not match what I have, so I want to do an IF statement in case the FileExist doesn't turn out that it can check if there is a file in there at all with either a specified date or using Today().

It's needing to be able to function just in the worksheet since the range of cells will always change constantly.

Please let me know if I can provide any other information!