On Mon, Jul 2, 2012 at 4:33 AM, Chen Peng <[email protected]> wrote: > Hi All, > My name is Chen Peng, I am a developer from Symphony. My special > areas are VBA and sw. > Now I found an issue about macros lost: > I saved an excel file with VBA to spreadsheet, the VBA can work > well in spreadsheet, then I wanted to save this spreadsheet back to excel, > but all the macros are lost.
How common is this scenario? Wouldn't the more typical user action be to re-save the document back to XLS format? Isn't that what happens by default when they do a save when editing an XLS file? If the user does this, will the macro be saved correctly? > I propose to save the binary data of excel VBA to spreadsheet, when > saving excel to spreadsheet, then we can get the binary data from > spreadsheet if need to save the spreadsheet to excel again. > The binary data will not impact the open/save... of the ODF format > application, it will not be touched when we operate the ODF formant > applications. The binary data will be just used when we want to save the > spreadsheet to excel, it is just a data prestore about saving spreadsheet > macros to excel. > Can you give some advice about the solution? > Any feedback will be preciated, thanks.
