Ruby saveas .XLSM, format code

[davesexcel]

I thought 52 was the code to save as an .xlsm file, but I get an UndefinedConversionError.

workbook.SaveAs("C;\TestFolder\TestAddImage.xlsm",52)

[slbaumgartner]

Did you accidentally post in the wrong forum? There is no workbook object and no SaveAs method in SketchUp or in native Ruby...

[Dan Rathbun]

No Steve, he's fine. He uses the Ruby standard WIN32OLE library to connect SketchUp with Excel workbooks.

This library basically exposes the VBA object model of Excel to Ruby. SO he's attempting to make a OLE call to Excel's VBA "SaveAs" method.

This is the entry page for the Excel VBA object model:
https://msdn.microsoft.com/en-us/library/ff194068.aspx

This page coves the Workbook object:
https://msdn.microsoft.com/en-us/library/ff835568.aspx

This page is for the Workbook.SaveAs method:
https://msdn.microsoft.com/en-us/library/ff841185.aspx

This page is for the XlFileFormat Enumeration, whose members are to be used in the 2nd argument to Workbook.SaveAs:
https://msdn.microsoft.com/en-us/library/ff198017.aspx

The XLSM format came out in 2007.
But has it been superseded in newer Office versions ?

List of Microsoft Office filename extensions:
https://en.wikipedia.org/wiki/List_of_Microsoft_Office_filename_extensions

Office Open XML (Microsoft invented standard, and copyright holder.)
https://en.wikipedia.org/wiki/Office_Open_XML

---

Not to be confused with:

OpenOffice.org XML (obsolete, superseded by OpenDocument):
https://en.wikipedia.org/wiki/OpenOffice.org_XML

OpenDocument (The FREE international standard):
https://en.wikipedia.org/wiki/OpenDocument

[Dan Rathbun]

@davesexcel said:

I thought 52 was the code to save as an .xlsm file, but I get an UndefinedConversionError.

> workbook.SaveAs("C;\TestFolder\TestAddImage.xlsm",52)
> 

As a general rule, try to use the interface's constants rather than direct use of integers. (The integers could change in the future and break your code.)

---

Microsoft forums:

Excel for Developers:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=exceldev%26amp;filter=alltypes%26amp;sort=lastpostdesc

Open XML Format SDK
https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=oxmlsdk%26amp;filter=alltypes%26amp;sort=lastpostdesc

[Dan Rathbun]

I did a search in the MS Excel Dev forum on "+SaveAs +xlsm +UndefinedConversionError", and got 947 hits. (You can browse those yourself.)

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=exceldev%26amp;filter=alltypes%26amp;brandIgnore=True%26amp;sort=relevancedesc%26amp;filter=alltypes%26amp;searchTerm=%2BSaveAs+%2Bxlsm+%2BUndefinedConversionError

At this point I would double-check that any macros in the Workbook do not have errors, that could give the file export routine issues.