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