"AA" wrote in message
...
Application.VBE.ActiveVBProject.BuildFileName ="c:\aa.dll"
Application.VBE.ActiveVBProject.MakeCompiledFile

The above ought to create c:\aa.dll but gives

Runtime error '748'
Method or Property is not valid for this type of project.

Why not?


Because you cant compile a dll from VBA, if you
could nobody would buy VB6 :)

Also, if it works, does it produce a Win32 DLL or an
ActiveX DLL?


Keith