saving with a date
Thank you, Tom.
--
Patricia
"Tom Ogilvy" wrote:
Some pseudo code:
dt = Date - 1
for each cell in Range("Holidays")
if dt = cell then
dt = dt - 1
exit for
end if
Next
Activeworkbook.SaveAs "C:\ABC\BaseName" & format(dt,"yyyymmdd") & ".xls",
xlWorkbookNormal
if you consider a holiday to include weekends, then it would involve more
checking.
--
Regards,
Tom Ogilvy
"Patricia" wrote:
Could anyone tell me how you can save a file with a date one day before
today's date but if it falls on a holiday to save it with the prior date.
Thank you.
--
Patricia
|