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 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) Any advice / suggestion are welcome. Thanks.
