Automation Error(-2147467259) in Properties Collection
--
HTH
RP
(remove nothere from the email address if mailing direct)
"VJ" wrote in message
...
Can somebody suggest me why I am getting "Unspecified Error" when the
following line of code executes.
Debug.Print
Application.Workbooks("WBName.xlt").VBProject.VBCo mponents.Item("FormName").
Properties.Item("ShowModal").Value
Before opening the workbook, I am unlocking it which is working fine but
for
some reason I am not able to get reference to the Properties collection.
It
works fine sometimes when I run in the debug mode.
Help would be appreciated.
Thanks,
|