Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VBA in my own Application

0 views
Skip to first unread message

Markus Glatz

unread,
Mar 5, 1998, 3:00:00 AM3/5/98
to

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

Jakob Praher

unread,
Mar 16, 1998, 3:00:00 AM3/16/98
to

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 <34FEF3...@gwdg.de>...

0 new messages