Multi-Thread execution from VBA

[David Rodríguez]

Hi all.

I'm working in a VBA application, and we have integrated a new module as a
VB .NET 2003 library.

We want to execute the dll in a different thread of the VBA execution, in
order to be able to continue working with the application while dll code is
running.


It is possible? Anyone knows how to do it?


Thanks in advance.

 

[Perry]

a different thread of the VBA execution,

May sound like semantic brubble but actually is very important
what do you mean with this ??

Krgrds,
Perry

 

[David Rodríguez]

Hi all.

I want to create an independent thead to be able to continue working with my
application while another process run at the same time(avoiding to force
user to wait until procces finish).

By the way, I found the way to do it, by using a .NET dll and the
CreateThread API Method.

The only thing I must do now is to recover my ADP integrity to be able to
see all changes I made (an unhandle error makes my ADP crash and it cannot
be opened).

Thanks.

Best Regards.