You'll probably want to do this with a Workbook_BeforeSave event. I don't
have any code here to copy, so that's about the best I can do for now. That
should get you started.

If you have named ranges tied to those cells, you could do something like this

SuggestedName = Range("Rangename1) & "_" & Format(Range("Date"),"yyyyy-mm-dd")

Just make sure you have values in each of the cells.

--
HTH,
Barb Reinhardt



"batmanz" wrote:

I want to save a workbook referencing a cell (with a name in it) and a cell
with a date in it (=today() )
I know very little about macros and I understand that this can be done using
a macro. do you use a button on the sheet assigned to a macro? what is the
format for a macro?
Can this be done without a macro?
in the end, i would like to be able to search by the date or by the name in
the cell