Microsoft excel is waiting for other program to finish OLE Action

[Deepak]

Hi,
I am trying to open an excel sheet by using VBA in
Excel. But, this particular sheet is maintained by other
person and is password protected. My code works perfect
when the file is opened by the other person
in the editing mode but fails to open the file when its
closed or not in the editing mode. I am not able to trace
the reason. I am left with this error message when the
file is closed by the other person.

"Microsoft excel is waiting for other program to finish
OLE action"

Code:
Dim xls as New Excel.Application

xls.workbooks.open("G:\sample.xls")

Excel fails when I try to open this location ... why does
it do so ??????????/

 

[BrianB]

I think you should be using something like this that checks if an
Excel application is running and opens one if not.

'------------------------------------------------------------
Dim xlApp As Object
On Error Resume Next
Set xlApp = GetObject(, "Excel.Application")
If Err.Number <> 0 Then 'Excel Not Active
Err.Clear
Set xlApp = CreateObject("Excel.Application")
End If
'--------------------------------------------------------------

Regards
BrianB
=============================================