hi Pman

That's why I check the extensions

Now with the new formats in 2007 you also have more control.
You can do only xls or xlsx or xlsm or ??



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pman" wrote in message ...

Thanks for your replies Norman and Ron. The Macro simply wasn't picking up
files to format. But I figured out why......I changed the filetype the Macro
looked up from "Microsoft Excel" to plain "Excel" and it picked up the files
to format :)

Thanks,

Prash