Post the code that you have so far...
--
HTH...

Jim Thomlinson


"Kevin Porter" wrote:

I want to be able to open a new workbook (which I can do) then save it as
workbook name + (value in B1 on open workbook, which will be a date).xls

How do I do this. I can open the workbook and name it and save it, but I
want to be able to add the date in B1 to the name.

Thanks.