MakeCompiledFile

  • Thread starter Thread starter AA
  • Start date Start date
A

AA

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.
 
AA said:
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?
Click to expand...

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?
Click to expand...

Keith
 
You can use this only on stand alone VB Projects (VBProject.Type =
101 = vbext_pt_StandAlone) not on normal workbook projects
(VBProject.Type = 100 = vbext_pt_HostProject).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top