Sure you can!
but you have to be familiar with COM (Component Object Model)
As you might know COM works with Interfaces and Objects.
An object has at least 1 Interface:
IUnknown
In order to communicate with VBA you have to make interface of the type:
IDispatch
It's a quite big issue you have to deal with, because you have to cast a lot
for instance the:
VARIANT types (which are not very common in C++ but in VBA)
To sum it up for you:
You need to implement an Automation Server with an IDispatch Inteface and do
your methods there, but MFC is very helpful when implementing this
functions, in particular the Control Wizzard.
But best would be, you check out some books about Automation, COM or
ActiveX.
I hope I could help you:
bye
Jack
Markus Glatz schrieb in Nachricht <34FEF34A.6...@gwdg.de>...
>Hello !
>Ist there a way to use VBA (VisualBasic for Applications) in my own
>Application with an extendet commandset definded by myself ?
>Thanks for the Help !
>Ciao,
> Markus