Method Open of Object Workbooks Failed

[akforsyt]

I need some help with this error. I have some VBA code in Outlook that runs whenever a task reminder goes off. The code is supposed to open a workbook, send email based on the info in the workbook, then close the workbook and quit excel.

The task reminders are set to go off every two hours. Sometimes this will work fine for days and then randomly (as far as I can tell) I get the error: "Method Open of Object Workbooks failed". If I press Debug and then Run without changing anything at all, it works fine.

I am using Outlook 2007 and Excel 2007. The workbook is a shared workbook on a network drive.

I can post code if needed, but will have to go to that computer.

Why do I occasionally get this error when the workbook definitely exists and has the same name and path? What does entering debug mode do that then allows the macro to run without error?

 

[akforsyt]

@Andrew
I did read the first link you sent. The second link is very helpful in explaining what this means.

@Brian
Everything else I have written has been in Excel referencing Outlook instead of Outlook to Excel. That explains why I was creating Outlook instances. I have learned VBA on my own and so I know I am missing a lot of the background knowledge.
What you explained makes a lot of sense and also explains several things that I have seen: several instances of outlook running, excel processes running after the workbook is closed, etc.

I will rewrite this and add what you and Andrew have suggested and let you know how it goes.

Thank you very much for your help.

 

[BrianB]

and yet you said

Yes. This is all in Outlook.

 

[akforsyt]

It's been quite a while since I first posted this. I appreciate everyone's help. I still had some issues with this even after following the recommendations here. What I ended up doing was rewriting my code so that I now use Excel VBA to control Outlook instead of Outlook controlling Excel. I am much more comfortable with Excel and found this easier to do.

 

[Nazeer]

I had the same issues. Instead of DoEvents. I just placed a MsgBox forcing the process to halt a while before executing OPEN command.