Hi,

From your question its not clear how you decide on the file name nor when
you want it to automatically save? What does DEFdef mean?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pravin" wrote:

I generate quiotations from a template and create a code name for each
quotation in cells B7 to F7 as follows.
TEMPLATE CODE XXX
QUOTATION CODE BUZ 7/07/2009 abc 156

Can I save this DEFdef,..) and the quotation number (156,157,...)
--
excelforautomatinginvoicing