Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft excel is waiting for other program to finish OLE Action
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 ??????????/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft excel is waiting for other program to finish OLE Action
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 ============================================= "Deepak" wrote in message ... 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 ??????????/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is waiting for another program OLE Action | Excel Discussion (Misc queries) | |||
Please help me --- Microsoft Excel is waiting for an OLE action | Excel Discussion (Misc queries) | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
Waiting for app to complete OLE action | Excel Programming |