Automation

Hello,

I have created an Automation application with MFC and I want export any data from my C++ application in VBA , where another developer can manipulate this data and should give me back new data, which I must use in my C++ application.

How can I get the same Automation object from VBA, that I have already in C++ application, manipulate the data this object and afterwards theese new data in my C++ application use again.

With best regards

generally you call a method of the object

==========================================

can you refresh my memory of the MFC abbreviation?

One very evident way to make this work is:
Create a out-of-process COM server.
The C++ App can connect to this and push in data.
The vB Object can take that data and do whatever.
It can then push it back into the COM-EXE. This can be made to trigger and event to which the C++ App is listening to.

Biplab

Microsoft Foundation Class