A
AL
Hi all,
I am uainf Excel 2000 VBA to try to recompile the vb project froom VBS code:
Sub RecompileVBA()
Dim VBProj As VBProject
Set VBProj = ThisWorkbook.VBProject
VBProj.BuildFileName = ActiveWorkbook.Name
VBProj.MakeCompiledFile
End Sub
I got a run time error 748 "method or property is not valid in this type of
project.
I save the workbook in name of Book1.xls.
THanks
Alex
I am uainf Excel 2000 VBA to try to recompile the vb project froom VBS code:
Sub RecompileVBA()
Dim VBProj As VBProject
Set VBProj = ThisWorkbook.VBProject
VBProj.BuildFileName = ActiveWorkbook.Name
VBProj.MakeCompiledFile
End Sub
I got a run time error 748 "method or property is not valid in this type of
project.
I save the workbook in name of Book1.xls.
THanks
Alex