thats brilliant thanks lot. just last question sorry to be pain. how
can i convert them back to "xls" . just for knowledge


You would need to change the name to remove the m from the end, and change

xlOpenXMLWorkbookMacroEnabled

to.... some other value - I don't have the list available, but it should be readily apparent when
you look at the list, for XL97 to 2003 format. Sorry for being so cryptic, but I don't have 2007
readily available.

HTH,
Bernie
MS Excel MVP