View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sabosis Sabosis is offline
external usenet poster
 
Posts: 47
Default Save file with date from cell

Hello

I have a macro that saves my workbook to a location on the network, but I would like to add the date to the filename, with that date coming from the value in cell F2. The current format for that cell is Data, but the filename will not accept "/". I would want the date format to be mmddyy. Any ideas?

Thanks