Using Excel to handle Com callback procedures

  • Thread starter Thread starter Aaron Graham
  • Start date Start date
A

Aaron Graham

I am relatively new to VBA. I am trying to access an SDK which requires
that I subscribe to callbacks to handle events. I am trying to handle
this in an Excel 2000 or XP workbook using VBA.

Is this possible? If so here is the reqired info I need, where do I
find this info:


Application name:
CLSID (or ProgID):
GUID

Aaron Graham
 
Anyone have any ideas????

Aaron Graham said:
I am relatively new to VBA. I am trying to access an SDK which requires
that I subscribe to callbacks to handle events. I am trying to handle
this in an Excel 2000 or XP workbook using VBA.

Is this possible? If so here is the reqired info I need, where do I
find this info:


Application name:
CLSID (or ProgID):
GUID

Aaron Graham
Click to expand...
 
¤ I am relatively new to VBA. I am trying to access an SDK which requires
¤ that I subscribe to callbacks to handle events. I am trying to handle
¤ this in an Excel 2000 or XP workbook using VBA.
¤
¤ Is this possible? If so here is the reqired info I need, where do I
¤ find this info:

What kind of events, those from Excel or from another application?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
These are Com events from another application.

Paul Clement said:
¤ I am relatively new to VBA. I am trying to access an SDK which requires
¤ that I subscribe to callbacks to handle events. I am trying to handle
¤ this in an Excel 2000 or XP workbook using VBA.
¤
¤ Is this possible? If so here is the reqired info I need, where do I
¤ find this info:

What kind of events, those from Excel or from another application?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
Click to expand...
 
If they are 'ActiveX' COM events, look at the VBA WithEvents keyword.
Otherwise, take a look at the AddressOf keyword.

--
 
If they are 'ActiveX' COM events, look at the VBA WithEvents keyword.
Click to expand...

RE they are not ActiveX
Otherwise, take a look at the AddressOf keyword.
Click to expand...

RE: I need to know what to pass to the subscription call so the other
program knows how to call me. Application name, CLSID (or ProgID), and
GUID.
 
Back
Top