I have a similar problem. I am trying to save an excel file as a text file. Since each worksheet need to be saved seperately iam saving the file as below. $Book->Worksheets($i)->SaveAs($filename) now i need to specify the file format for the file that is being saved. MSDN documentation says that the fileFormat should be Excel.XlFileFormat.xlTextWindows but how do i specify this in the SaveAs function is there any way of doing this! any pointers would be greatly helpful pls copy ur response to Swaroop.m@gmail.com Swaroop