Macro's are not preserved currently when you rewrite a spreadsheet. They are stored as separate streams. It should be possible and patches will be considered but there are no immediate plans by the committers to add this functionality.
Regards, Glen ----- Original Message ----- From: "Andrew C. Oliver" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 2:09 AM Subject: Re: Rewrite a xls with macros > Alexandre Luti Telles wrote: > > >Hi > > > >I haven't studied the xls format yet, but how difficult it would be to read the macros, store it in a binary variable, and write it back to the file? > >Would this work? > > > possibly. I think they're stored in a seperate entry in the POIFS part > of the file (OLE 2 CDF) > > > > >My problem: > > I must generate a xls file dynamically with information from the DB, and this file must have some VB code. Is there a way to create the information I need in a different file and then insert this sheet in the existing xls with macros? (I can use any language) > > > > I would question the need for the Macros. Why do you need macros? > > -Andy > > > > >Any advice / suggestion are welcome. > > > >Thanks. > > > > >
