Automation Error in Excel VBA
If this is refering to a real template, the name of the workbook you are
refering to won't be the name of the template if it was opened with
File=New and then the template was specified.
--
Regards,
Tom Ogilvy
"VJ" wrote in message
...
Yes, I have referenced to Microsoft Visual Basic for application
extensibility for 5.3.
I am also able to compile it and and it works fine in the debug mode.
"Fredrik Wahlgren" wrote:
"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
|