lucky you

i created a similar macro

ActiveWorkbook.SaveAs FileName:=strSavePath & strBestandsnaam

in this case the filename is just a string ;-)

good luck!

" wrote:

I want to add a Save button on to an Excel spreadsheet that will
automatically save the sheet to a predetermined location with a
filename like Mike08March07. The idea is that the user can open the
template file everyday and each days recordings will be saved into the
predetermined location e,g F:/Jobs2007/. I dont want to create a form
but just add a button from the Control Toolbox, drop it onto the
worksheet and write the code for it.Does anyone know how to do this?