VBA SaveAs with Future Date appended to File Name

[cma2012]

Hello,

I require help developing code to save a workbook created today for a business day / weekday at T+2. The file used to be saved as date format Now however the requirement has changed to name the file at T+2.

Here is the code with the amended change to Date 2 but it doesn't work with the change:

Please Login or Register  to view this content.

Thank you for your attention.
Cheers ~L.

[jonnipeel]

Please Login or Register  to view this content.

[cma2012]

Great thank you! Minor changes for format and correct to relable dDate as defined sDate.

Cheers!

[cma2012]

Hello again,

I actually need the code to save as T+2 but when a weekend or longweekend occurs the save date should be the next business day. So for example the code saved today's report as 30Sept2012 when it should be 01Oct2012.

Please help to structure for business days?
Thank you!