As I understand it, the main advantage in a DLL is to avoid cross process
marshalling, which, especially for COM, is expensive.
You would have to add some Public classes in order to interact with the DLL
objects.
Depends on what you are currently doing, but should not be too difficult.

NickHK

"avi" wrote in message
ups.com...
Hello,

I have developped an exe application from vb6 that i call from VBA
with shell statement. It works fine although runs quite slow when the
spreadsheet is large and the application has to deal with a lot of
comm. with Excel.

The application starts a form by wich all the actions are preformed.

I woud like to know if and how to transform the exe into a dll, so
communication with excel should be faster

Any guidance will be very appreciated

Notes:

My knowledge in class stuff in VB6 is quite elementary
In a previous post i've got strong recommendation to dll my
application, but due to a lack of knowledge, i have preferred the
straightforward and more easy exe way but paid with a lack of
efficiency