merrymonk, what version of Excel are you using and which version of Excel file are you wanting to save it as? Based on the error message that you described, it sounds like you saved the Excel file in one version format and when you manually opened the file, Excel was expected a different version format.

• If you're using Excel 2003:
  • You can only save the file as Excel 2003 format, which means you need to use .xls file extension.
• If you're using Excel 2007 and want to save it in Excel 2003 format:
  • You need to use the .xls file extension and need to add FileFormat parameter to the SaveAs method.
  • Example: $workbook->SaveAs(Filename => "C:\\test.xls", Fileformat => xlExcel8);
• If you're using Excel 2007 and want to save in Excel 2007 format:
  • You need to use the .xlsx file extension.
  • I forgot the full reasons behind it and it might not apply to your situation, but one of my scripts has an additional parameter for the SaveAs method in this scenario.
    Example: $workbook->SaveAs(Filename => "C:\\test.xls", ConflictResolution => xlLocalSessionChanges);

Hopefully this information will help point you in the right direction in debugging the problem.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.