I have a folder that gets updated with excel sheets a few times a week. The files are in the format that follows:
\\snj1afsfs16\investmentm$\Daily_Transaction_Files\AXA Transactions Summary mm dd yyyy.xls
I would like to tell my macro to open the file that matches with a function giving today's date "=Workday(Today(),-1)" that I inserted in excel in cell B12 let's say. If the macro can't find the file for that date (which happens), then I'd like a Messagebox to pop up stating that it couldn't find any transactions for today's date. How would I do so?
Please help! I just started with VBA and truly need some help!
Cheers
Bookmarks