Re: Rewrite a xls with macros

2002-04-16 Thread Glen Stampoultzis
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 diffic

Re: Rewrite a xls with macros

2002-04-16 Thread Andrew C. Oliver
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

Rewrite a xls with macros

2002-04-16 Thread Alexandre Luti Telles
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? My problem: I must generate a xls file dynamically with information from the DB, and this file must have some VB code. Is t