Hi Ani,

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel


Check out this article:

http://www.jkp-ads.com/articles/CorruptFiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com