Out of sheer curiosity, I wanted to test and see what
compiling a VBA Excel program as a .DLL does for
one. So I added the VBIDE Extensibility library to my
list of references, and then added the following code to
one of my shorter Excel programs:

Sub CompileDLL( )
ThisWorkbook.VBProject.BuildFileName = "C:\TEST.dll"
ThisWorkbook.VBProject.MakeCompiledFile
End Sub

When I ran the program which called the above routine the
BuildFileName instruction went okay, but the next line bombed
with the error message "Method not applicable to this type project."
Can someone tell me what type projects can be compiled as a
..DLL, and the advantages, if any, of doing so.

-- Dennis Eisen