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

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

'Declarations:
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.

Regards
Helga

Helga Anagnostopoulos
helga.ana@shandutech.co.za

Hey,

You may need to do something like this:

http://p2p.wrox.com/topic.asp?TOPIC_...Terms=dcomcnfg

Brian