"VJ" wrote in message
...
Hi,

I am getting the following err If I tried to access the properties of the
form during run time from another workbook.

Method 'Properties' of object '_VBComponent' failed -2147467259

Following is my code Set mynewform =
Workbooks(template_Name).VBProject.VBComponents.It em(module_Name)
With mynewform
For Each FormProperty In .Properties
If FormProperty.Name = "ShowModal" Then
FormProperty.Value = False
End If
Next
End With

But If I run the same code in debug mode, It works fine.

Can somebody suggest me any way around?

Thanks,



Have you set a reference to the VBA Extensibility library?

/Fredrik