Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plz help me ...
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 ??????????/ |