• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 824
  • Last Modified:

Lotus Automation

Anyone on this forum familiar with “Microsoft Office Automation”

Can Lotus 123 be similarly “Automated” ?
0
Greg Rowland
Asked:
Greg Rowland
  • 5
1 Solution
 
RanjeetRainCommented:
0
 
RanjeetRainCommented:
Code example from the same page:



123 Example

This code example instantiates a 123 Object and sets the object to a Variant variable. The application's Visible property is set to true. A new 123 workbook is created and set. A range is set. The contents of the first cell on the sheet is set to a string. The user is prompted to close the application with a messagebox. The application is then closed.

Dim w123 As Variant
Dim doc As Variant
Dim r As Variant
Set w123 = CreateObject("Lotus123.Workbook")
w123.Application.Visible = True
Set doc = w123.Application.NewDocument
Set r = doc.Ranges("A:A1..A:B10")
r.Cell(0, 0, 0).Contents = "Hello 123 from OLE Application"
MessageBox "Close 123"
w123.Application.QUIT


0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerAuthor Commented:
Good information, I am trying to do this in Delphi 7.0
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RanjeetRainCommented:
I am not aware of Delphi equivalent of the code. But this much of info is more than enough for even an avearge Delphi programmer to begin with. Just see how you create the Application Object or its equivalent. Use an Object Explorer to learn the Object Model as exposed by the Automation Server, and you are ready to go.
0
 
RanjeetRainCommented:
>> Anyone on this forum familiar with “Microsoft Office Automation”

Can Lotus 123 be similarly “Automated” ?


The answer to your question was simple. "YES".

I don't really think that was a grade to give. Please ask in the community support to have the grade changed to A.
0
 
RanjeetRainCommented:
Thank you so much ee_ai_construct !!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now