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. >
