Automatic Saving

Hi all

Am having a macro which validates all the datas, once the validation is completed i want the file to be saved as new excel in a particular path with the specific file with today's date.

EG: Sample 22-02-2013.xls

can anyone pls assist with a code

Hi Raga

Thanks for the code its working fine but the file as been as macro enabled sheet can u pls suggest how to save it as excel file

Please Login or Register  to view this content.

It is working fine thanks a lot