How can I catch events from code-object?

[Jhd.Honza]

Hi!

If I want to use eg. WinSock on formless application, I have to use CreateObject method.

But how can I tell what to do if an event occurs (DataArrival, ConnectionRequest, etc.)??

[Joacim Andersson]

Declare the object with the WithEvents keyword.

[Yonatan]

This won't work with your winsock.
Use a winsock classmodule, I think it can be found somewhere on Planet Source Code.

[Jhd.Honza]

OK, so how can I catch the events on external objects, for example excel (have I to found Excel classmodule ?); I did not mean only WinSock...

PS: Can you please tell me where is the WinSock classmodule?

Thanks,
John

[Joacim Andersson]

Set a reference to Microsoft Excel Object Library and declare an object with the WithEvents keyword.

Private WithEvents xl As Excel.Application

Add the above line to the general declaration of a form or a class module.
Click down the Object combo box in the code window and choose xl. And there you go...

[Joacim Andersson]

Just as parksie said; you can't use WithEvents in a normal module. But you can use it in a Form module if you like.

If you remove the reference VB can't compile the application because it doesn't know what Excel.Application is then.

You can, however, declare it as a general object but not if you want to use events.

Private xl As Object 'this works without having any reference
Private WithEvents xl As Object 'you can NOT use WithEvents with an Object object

But why do you want to remove the reference?
Even if the end user doesn't have Excel you won't get any errors before you try to create the object.
But that error is trappable if you use On Error code.