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,