how do I save a worksheet as the current date and time? Excel 2003
V Vasant Nanavati Jun 3, 2004 #2 You cannot save a worksheet. You can save a workbook as follows: ActiveWorkbook.SaveAs Format(Date, "d-mmm-yyyy") & " " & Format(Time, "h:mm AM/PM") & ".xls"
You cannot save a worksheet. You can save a workbook as follows: ActiveWorkbook.SaveAs Format(Date, "d-mmm-yyyy") & " " & Format(Time, "h:mm AM/PM") & ".xls"
