View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sonic_d_hog sonic_d_hog is offline
external usenet poster
 
Posts: 1
Default Macro to save Excel file with date and time in the file name?

Does someone out there have a macro that when executed would save the current
Excel spreadsheet in the form "filename-current date-current time.xls" and
leave the file open for editing? Ideally, I would like to pin the macro to a
button on the user's toolbar. Thank you for you help in advance.
Troy