When you have a repetitive Excel task you want to automate, you turn to Macros: a code written in VBA that can be inserted into Excel files to perform specific tasks like inserting text on a button click or performing calculations that cannot be done using in-built Excel functions.

Excel for WinForms now supports OpenXMLMacro file format, with which you can save and load Macros-enabled Excel files in C1Excel. Alternately, you can also load and save such files from and to *.xlsm file extension. The VBA Code is loaded in Binary format into xlsm files.

If you're saving your macro-enabled files to '*.xlsm', you don't need to specify FileFormat OpenXMLMacro to save the file. You can save the file using following code:

c1XLBook1.Save(xlsFileName);

Alternately, if you want to save macro enabled files to a stream or any other excel extension, you can save the file using:

c1XLBook1.Save(xlsFileName, FileFormat.OpenXMLMacro);

Here's an example of how C1Excel loads and saves Macro-enabled Excel file.

ComponentOne Studio Excel for WinForms OpenXMLMacro

The Macro calculates Last Day of a Month from a Date column. C1Excel loads and saves file using following code


// Copy Macro enabled Excel File
string xlsFileName = "..\\..\\XlsxTestBin.xlsm";
c1XLBook1.Load(xlsFileName);
c1XLBook1.Sheets[0][0, 0].Value = "It is copy!";
xlsFileName = xlsFileName.Replace(".xlsm", "Modified.xlsm");
c1XLBook1.Save(xlsFileName);

Open the Modified.xlsm and you'll find the Macros preserved.

Note: C1Excel can load and save only opaque copy of Macro code. Also, C1Excel does not support any properties to add VBA code. Macros will be deleted if you save a file having macros to .xlsx/xls file.
Already have a subscription? Go to C1Studio to update your version!

Download your 30-day trial to try out OpenXMLMacro in Excel >>

Read more about Excel for WinForms>>