Hi ,
what macro do ineeed to create if i need to save my workbook with the
date mentioned on one of the cells in that rec and the filename.

for example if i have mentioned the date as 17th Jan06 on one of the
cells than i want the macro to save my file at a particular place in my
drive with the date featuring in the filename like "File011706.xls". ie
it shud automatically identify the date and save my file.

any help appreciated
Anand


--
mehta_agm
------------------------------------------------------------------------
mehta_agm's Profile: http://www.excelforum.com/member.php...o&userid=30518
View this thread: http://www.excelforum.com/showthread...hreadid=502358