Excel poisoning #1: saving xlsm from template macro

Here are few hints, based on my recent “Excel poisoning” 🙂

Working with template, in C#, want to save xls macro file, without security warning:

myWB.SaveAs(fileNameXLSM,
XlFileFormat.xlOpenXMLWorkbookMacroEnabled,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);

where fileNameXLSM may be “c:\…\myFileWithMacro.xlsm” (extension required!),
and “XlFileFormat.xlOpenXMLWorkbookMacroEnabled” is the magic key, in Excel 2007. 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: