Plz help me ...

[Deepak]

Hi,
I am trying to open an excel sheet by using VBA in
Excel. But, this particular sheet is maintained by other
person in the company 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 ??????????/

 

[AxeldraX]

i think the raison is that you will open a file that i
paswordprotected. in the helpfile from Excel you find how to protec
the file but not to open the file