VBA (Visual Basic for Applications) Question:
Download Job Interview Questions and Answers PDF
Explain Advantage of ActiveX Dll over Active Exe?
Answer:
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.
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.
Download VBA Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain Benefit of wrapping database calls into MTS transactions? | Explain technical reasons which made Microsoft withdraw its support for VBA in Mac? |