save xlsx files

Question

Hi
I try to save a file in xlsx format, but I get a:
"This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type."

the failing code look like this:

xlWorkBook.SaveAs(fileName, Excel.

XlFileFormat.xlExcel12, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlNoChange, misValue, misValue, misValue, misValue, misValue);

What is the correct syntax?
I can get it work with saving to xls file.

Regards
Kim

Answer 1

Hi Kim, this forum is for software developers who are using the Open Protocol Specification documentation to assist them in developing systems, services, and applications that are interoperable with Microsoft Office Open File Formats. The Microsoft Office Open File Formats can be found at: http://msdn.microsoft.com/en-us/library/cc313118.aspx. Since your post does not appear to be related to the Microsoft Office Open File Formats documentation set we would appreciate it if you could try the Excel Programming Discussion Group http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.programming&cat=en_US_3a793e1f-4961-419d-9ec7-899d6e6086cd&lang=en&cr=US instead to find the information you are looking for. Thanks!

Richard Guthrie
Escalation Engineer - Open Protocols Support Team