VBA (Visual Basic for Applications) Interview Question:

Explain Advantage of ActiveX Dll over Active Exe?

Submitted by: Administrator

Advantages of ActiveX Dll

1) An in-process component shares its client?s address space, so property and method calls don?t have to be marshaled. This results in much faster performance.



Disadvantages of ActiveX Dll

1) If an unhandled error occurs it will cause the client process to stop operating.



Advantages of ActiveX Exe

1) The component can run as a standalone desktop application, like Microsoft Excel or Microsoft Word, in addition to providing objects.

2) The component can process requests on an independent thread of execution, notifying the client of task completion using events or asynchronous call-backs. This frees the client to respond to the user.

3)If an error occurs the client processes can continue to operate.



Disadvantages of ActiveX Exe

1) Generally slower than an ActiveX dll alternative.
Submitted by: Administrator