save xlsx files

K

Kim Carlsen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Why am I getting this error? 0
Save workbook without shapes 0
hope someone can help with excel save with 2003 and 2007 installed on my computer 9
Help with copying a sheet from One workbook to another workbook 1
Apply Excel Macros to another open file 1
ADO connection to Excel 2007 *.xlsx files? 8
How can I save directly into the same folder every time in Office 365 / Windows 10? 0

Top