I have a code that I would like the code to look for the format of the file
path and the file name plus one month. So that today (April) it would be
looking for the file with name May. Example:

"G:\CC folder\Accounts\grape juice\LA Sheets\Concord " & Format(Date,
"mmm-yyyy") & ".xls"

Thanks for any help in advance!