Thanks to all , it worked when i specifed FileFormat => 52. Ya string "xlOpenXMLWorkbookMacroEnabled" instead of 52 should also work. And yes we require MS 2007 installed.