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