Wrox Programmer Forums
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 20th, 2004, 06:45 AM
Registered User
Join Date: Sep 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lotus 123 Workbook

I need to generate (and eventually import) a lotus 123 worksheet.

I figured the dom out (+/- Same than VB) and has this code done:

Dim appSheet as Lotus123.Application

'Now here is the snag:
set appSheet = GetObject(, "Lotus123.Application")
if (err.number <> 0) then
  set appSheet = CreateObject(,"Lotus123.Application")
end if

'Error = Active X Object can not be created.

I tried inserting the or using Lotus.Application but no luck.

I would really appreciate help.


Helga Anagnostopoulos
Old September 20th, 2004, 08:30 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts


You may need to do something like this:



Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with Lotus Notes Warbird VB How-To 1 November 13th, 2007 01:06 PM
Lotus approach and .NET joeri VS.NET 2002/2003 3 August 10th, 2007 08:47 AM
Page 123 - Login Box Correction xumuskiefan BOOK: Professional Crystal Reports for VS.NET 1 February 2nd, 2006 01:06 PM
Lotus Notes GuyB ASP.NET 1.0 and 1.1 Basics 0 December 27th, 2005 07:01 PM
123 IN LUCK C# 0 April 3rd, 2005 09:12 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.