| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code issue - before_save() - Filename with date stamp - worksheet
Could someone tell this tourist why this is not working please??
Private Sub Workbook_BeforeSave() With ActiveSheet .Name = "As of " & Format(Now(), "MM-DD-YYYY") End With With ActiveWorkbook .Name = "{FILENAME}" & Format(Now(), "yyyymmdd" & ".xls") End With End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date stamp when a value is entered in a cell on another worksheet | Excel Worksheet Functions | |||
| How date stamp & save filename? | Excel Programming | |||
| Multiple Date Stamp & Worksheet Change macros | Excel Programming | |||
| Filename Issue | Excel Programming | |||
| Need Before_Save code | Excel Programming | |||
Threaded Mode
