| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving a file with a date | Excel Worksheet Functions | |||
| Saving to subdirectory using date() | Excel Programming | |||
| Date not Saving As Expected | Excel Programming | |||
| Saving file as a date | Excel Programming | |||
| Saving with date in filename | Excel Programming | |||
Hybrid Mode
