View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AA[_2_] AA[_2_] is offline
external usenet poster
 
Posts: 4
Default MakeCompiledFile

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?

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

Thanks.