Start Lotus 123

hi

Using VB6 this will work perfectly but when i use the same statement for lotus 123. It just does not work

Dim objExcel as Excel.Application
Set objExcel = New Excel.Application

the dim statement it's ok but when iI try the set statement in order to create a new instance it just doesn't work
what am I doing worng ???


Thanks for your time

I do hope you have set the Project References to Lotus 123 and not left them as MS Excel hoping them to work!!?

I have never used the Lotus 123 object library (I didn't even know it had one) - but if you have set a reference to it in your projeft then look at VIEW / OBJECT BROWSER, pick the Lotus 123 library and see if that helps. You may find it doesn't have an Application object, for example.

Thanks for the prompted help.

I did set up my lostus 123 reference, and the strange thing is tha when setting up my dim lotus as lotus123. the dropdown list comes up with no problem like i would on excel, but when I set my object is like is not there.

Thanks for your help