<div>
Look at the VBA (Visual Basic Application) for excel in the Excel help for ideas. Or create a macro in Excel doing roughly what you want to do and then edit the macro and copy the code and paste it into your LotusScript. With a coupe of tweaks it will work.
</div>


Look at the VBA (Visual Basic Application) for excel in the Excel help for ideas. Or create a macro in Excel doing roughly what you want to do and then edit the macro and copy the code and paste it into your LotusScript. With a coupe of tweaks it will work.

<div>
<div class="content wysiwyg-content">
I am trying to create an agent that will create Excel reports from our Lotus Notes database. I found some examples on the web how to do some of the things that I want from the example. But I would like to know if there is some kind of help file that can tell me the properties and method for the Excel.Application just like Designer help for LotusScript. I would like to find that so that I can read through some of the things that I do not understand.
</div>
</div>


I am trying to create an agent that will create Excel reports from our Lotus Notes database. I found some examples on the web how to do some of the things that I want from the example. But I would like to know if there is some kind of help file that can tell me the properties and method for the Excel.Application just like Designer help for LotusScript. I would like to find that so that I can read through some of the things that I do not understand.

Excel help for LotusScript

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.

Lotus IBM

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.