I have a template which I use each week to produce a new workbook.

I name the weekly workbook with a week number generated by a formula
dependent on the date of the calculation.

How can I "capture" the output of the formula and use it within a Macro
to name the workbook each week?

Jonathan Grodzinski



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/