Activeworkbook.SaveAs Format(Date,"mmddyyyy") & ".xls"

--
HTH

Bob Phillips

"sd look" wrote in message
...
Trying to get a macro to copy a pivot table from current workbook to a
separate workbook and save with the current date in the file name, e.g.
04272005 Table.xls. How can you code this in a macro to perform?
--
Thanks,
SD Look