ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Excel to handle Com callback procedures (https://www.excelbanter.com/excel-programming/290126-using-excel-handle-com-callback-procedures.html)

Aaron Graham

Using Excel to handle Com callback procedures
 
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

aGraham

Using Excel to handle Com callback procedures
 
Anyone have any ideas????

In article
,
Aaron Graham wrote:

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


--
o_o_o_o
/| ,[_____],
|ŻŻŻL --O|||||||O-
()_)Ż()_) ŻŻŻŻŻ )_)

Paul Clement

Using Excel to handle Com callback procedures
 
On Tue, 03 Feb 2004 14:16:05 -0500, Aaron Graham wrote:

¤ 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 ~~~
Microsoft MVP (Visual Basic)

aGraham

Using Excel to handle Com callback procedures
 
These are Com events from another application.

In article ,
Paul Clement wrote:

On Tue, 03 Feb 2004 14:16:05 -0500, Aaron Graham
wrote:

¤ 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 ~~~
Microsoft MVP (Visual Basic)


--
o_o_o_o
/| ,[_____],
|ŻŻŻL --O|||||||O-
()_)Ż()_) ŻŻŻŻŻ )_)

onedaywhen

Using Excel to handle Com callback procedures
 
If they are 'ActiveX' COM events, look at the VBA WithEvents keyword.
Otherwise, take a look at the AddressOf keyword.

--

aGraham wrote in message ...
These are Com events from another application.

In article ,
Paul Clement wrote:

On Tue, 03 Feb 2004 14:16:05 -0500, Aaron Graham
wrote:

¤ 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 ~~~
Microsoft MVP (Visual Basic)


aGraham

Using Excel to handle Com callback procedures
 
In article ,
(onedaywhen) wrote:

If they are 'ActiveX' COM events, look at the VBA WithEvents keyword.


RE they are not ActiveX

Otherwise, take a look at the AddressOf keyword.


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.




--

aGraham wrote in message
...
These are Com events from another application.

In article ,
Paul Clement wrote:

On Tue, 03 Feb 2004 14:16:05 -0500, Aaron Graham
wrote:

¤ 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 ~~~

Microsoft MVP (Visual Basic)


--
o_o_o_o
/| ,[_____],
|ŻŻŻL --O|||||||O-
()_)Ż()_) ŻŻŻŻŻ )_)


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com