Thread
:
MakeCompiledFile
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
MakeCompiledFile
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
"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?
Also, if it works, does it produce a Win32 DLL or an
ActiveX DLL?
Thanks.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson