Is it possible, using LotusScript in R5, to add Notes data to an existing Excel file, when the target file (1)has multiple sheets, (2)the bottom portion of the first sheet -- where the data will be written -- is formatted differently from the top (different column headers), (3)the target columns are merged, and (4)the cell merging in this bottom section does not coincide with cell merging that exists in the top portion? If so, do you have any tips in regard to addressing the target columns?
Assuming that you're running this on an operating system that supports OLE automation, and that has Excel installed, yes, that should not be a problem. There's nothing you can do in Excel that you can't automate. In fact, by using the Record Macro function you can have Excel write the VB code for you -- with a little tweaking, this same code will work in LotusScript.
For more information reference "COM Together -- with Domino."
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on LotusScript
Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony.
Discover options you can use if you'd like external users to be able to access a workflow-based Notes Domino application through different ...
Learn why you may receive the error message: "Illegal circular use: Audit Trail" when trying to open Lotus Notes documents that use copied forms.