Hi i have a macro that copies a worksheet and saves in my documents. My
guestion is there a way to save the file with the current date each time.

thanks

Hi,

Something like;

ActiveWorkbook.Save Environ("userprofile") & "\my documents\my filename " &
Format$(Now, "dd-Mmm-yyyy") & ".xls"

(replace ActiveWorkbook with however you reference your workbook with new
sheet)

Regards,

Chris.
--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"coconutt" wrote:

Hi i have a macro that copies a worksheet and saves in my documents. My
guestion is there a way to save the file with the current date each time.

thanks