Adding a macro to Excel from VB
Posted by Antonio Suárez Pozuelo on April 06, 2001 2:20 AM
I've developed a web application that uses a reporting component to generate Excel documents when requested by clients. The component is invoked from a dll written in VB. Now I need to add some macros to the generated document prior to download; the reporting tool doesn't feature that, but I've been told that it can be done via 'OLE automation'. I'm not quite sure what's that. I'm trying the Microsoft Excel 8.0 object library, but can't find any suitable objects, methods or properties for that. Any ideas? It's important for me, so I'd appreciate your help very much. Thank you in advance.