Opening and saving files that have a date in the file name

I'm trying to use VBA (Excel 2013 & Excel 2010) to open an existing worksheet with a file name that contains a date - specifically, the date of the last business day. But I'm having trouble identifying the most efficient way to use VBA to account for weekends and holidays. I've found the WORKDAY function does not work "directly" in VBA, but I've been successful in defining cell formulas in Excel via VBA.

The following code works when opening and saving files, but does not account for weekends and holidays:

Please Login or Register  to view this content.

This code successfully creates a new sheet called "Dates", but does not allow me to open a workbook with a date in the file name.:

Please Login or Register  to view this content.

The error I receive reads, "Sorry, we couldn't find 'Q:\Transfer\June\VBA\2014-01-06_Outages.xlsx". Is it possible it was moved, renamed or deleted?" I've confirmed the file does exist, and the original code listed above has no trouble opening the file.

Is there a tag/command/flag somewhere that I'm missing?

Thank you!

I've figured out what was wrong! In my second block of code, I had coded an incorrect date format, which is why it couldn't open my existing file (it was looking for 2014-01-06_outages.xlsx instead of 2014-Jan-06_outages.xlsx). Here's the updated code:

Please Login or Register  to view this content.