tags:

views:

49

answers:

0

I am writing a program that writes to Excel files. I am restricted to writing to Excel 2007, which is fine, and I'm using EPPlus, which is a great utility. The thing is that I need to have macros and VBA enabled for an update function in the sheet, but EPPlus will only write to .xlsx files, not macro-enabled .xlsm files. If I try to write to .xlsm files it won't open.

Is there another code library that lets me accomplish what I need (again that's writing to Excell 2007 Macro-enabled workbooks)?

EDIT: What I really need is to be able to insert the .bin file with the VBA macros and the relationships to that file in the XML specs withing the .xlsm file. And have it work.