Call VB.net routine from VBA

[Charlie Mac]

VBA Geru's

I want to call a VB.Net routine multiple times (passing each sentence
of a long document and returning a value for each sentence). Is
"Call..." or "Execute..." the syntax to call an extermal routine?
Does anyone know of problems like memory leaks or Word's limitations
for so many iterations? Thanks.

Take care,

Charlie from Texas

 

[Cindy M -WordMVP-]

Hi Charlie,

VBA Geru's

I want to call a VB.Net routine multiple times (passing each sentence
of a long document and returning a value for each sentence). Is
"Call..." or "Execute..." the syntax to call an extermal routine?
Does anyone know of problems like memory leaks or Word's limitations
for so many iterations?

You don't mention what kind of "container" the .NET code is in? Is it a
DLL in a VSTO project or managed COM-Addin? Something else?

In general terms, calling code in a DLL (whether straight COM or
managed COM) requires a callback in the VBA project to the COM-Object.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail