Excel is waiting for another application to complete an OLE action

[dasiga444]

I am using Excel 2003. I have an Excel 2003 file "FileA.xls" which opens an another Excel 2003 file "FileB.xls " in its Workbook_Open Event.

Now the new file "FileB.xls" has a lot of processes running in its Workbook_Open event and that workbook closes itself after all those process are successfully executed.

I am trying to open and run the file "FileA.xls" with a Windows Task Scheduler. Now, the file "FileA.xls" opens and in its Workbook_Open event, it also invokes and opens the "FileB.xls" file.
But I am getting an error
"Excel is waiting for another application to complete an OLE action."

This error message reoccurs every 10 seconds. How can I over come this? Please suggest.

 

[kjv1611]

Try adding in DoEvents just before and/or just after the VBA code for opening FileB.xls

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57