in reply to Re^3: Problem using SaveAs when trying to change Excel format
in thread Problem using SaveAs when trying to change Excel format

Why don't you try giving SaveAs parameters exactly like in the OP?
  • Comment on Re^4: Problem using SaveAs when trying to change Excel format

Replies are listed 'Best First'.
Re^5: Problem using SaveAs when trying to change Excel format
by Anonymous Monk on Jul 09, 2014 at 11:43 UTC

    OP?? I'm sorry. kindly explain.

      OP as in ... i should have done it like below :

      $Book->SaveAs($file_name) ???

      Though this also isn't of any help. i have already tried it. I'm stuck here...don't know how to proceed here. Kindly help!!!

        $Book->SaveAs($file_name);

        works for me, unless the file $file_name is already existing. I usually solve that problem by trying to delete the file before overwriting it.

        If SaveAs() is still not working, verify the path (and try both, slashes and backslashes - excel seems to be a bit picky about them)

        HTH, Rata