Call VB.net routine from VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlie Mac - 10 Apr 2006 16:28 GMT

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

Reply to this Message

Cindy M -WordMVP- - 11 Apr 2006 11:03 GMT

Hi Charlie,

> VBA Geru's
>
[quoted text clipped - 3 lines]
> 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 :-)

Reply to this Message

Rate this thread: