HI,
I have XLSM file, where we have some macro coding with lots of calculation, Now I want to regenerate XLSM original file against my user input.
Hi,
Are you just modifying the SpreadsheetML markup, or are you trying to modify the VBA macros per the user input? If you are modifying the SpreadsheetML, I believe you can do so as you've always done. If you want to modify the VBA, this is an entirely different proposition.
Take a look at [MS-OFFMACRO]: Office Macro-Enabled File Format Specification, which details how macros are stored in IS29500 (Open XML). Also take a look at [MS-OVBA]: Office VBA File Format Structure Specification, which documents the internal structure of the binary parts that store the macros.
-Eric