PC Review


Reply
Thread Tools Rate Thread

Automation Lotus 1-2-3 Objects

 
 
=?Utf-8?B?am9yZGlnYXJk?=
Guest
Posts: n/a
 
      28th Jul 2005
Is it possible to control Lotus 1-2-3 from within Excel?
 
Reply With Quote
 
 
 
 
Andy Wiggins
Guest
Posts: n/a
 
      28th Jul 2005
Here's some sample code that:
- creates a 123 spreadsheet
- inserts some text
- changes the text to bold
- saves the spreadsheet to a file in the c:\temp directory
- tidies up

''
***************************************************************************
'' Purpose : Create a Lotus 123 file from Excel's VBA
'' Written : 14-Jun-1999 by Andy Wiggins - Byg Software Ltd
''
Sub mRun123ProUsingVBA()
Dim app As Object
Set app = CreateObject("Lotus123.Workbook")

With app
.Parent.Visible = True

With .ranges.Item("A:A3")
.contents = "Demo from BygSoftware.com"
.Font.Bold = True
End With

.SaveAs "c:\temp\BygSoftware.123"
.Parent.Quit
End With

End Sub

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"jordigard" <(E-Mail Removed)> wrote in message
news:F8C81D33-1167-4AB8-ACE8-(E-Mail Removed)...
> Is it possible to control Lotus 1-2-3 from within Excel?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with Lotus Notes Automation!!! 23izkool Microsoft Excel Programming 0 5th Mar 2011 11:49 AM
Need help wih Lotus Notes automation Nick via AccessMonster.com Microsoft Access VBA Modules 6 5th Mar 2011 01:38 AM
Anyone using lotus notes automation classes Joe Microsoft C# .NET 1 16th Dec 2006 11:44 AM
Automation objects Alain Microsoft Access VBA Modules 3 14th Jul 2004 11:12 PM
Email Automation: Lotus Notes =?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?= Microsoft Access Form Coding 1 23rd Jun 2004 10:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:45 PM.