View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Guy[_2_] Guy[_2_] is offline
external usenet poster
 
Posts: 47
Default Macro to Insert Current Date into cell - Macro to "Save As"

Windows XP - Office Basic 2003 - Excell 2003

1) I need a macro that will insert the current date into a cell. I do not
want the date to change when the sheet is opened or modified and saved unless
that macro button is selected.

2) I also need a macro that will bring up the "Save As" window when button
is selected. If possible to also insert a particular cell value in name field
of "Save As" window, then save and exit all with same macro.

Thanks,
Guy