Error: Excel waiting for another application to complete an OLE action.

Hello. I am having an issue with some code. The goal is to click a commandbutton on a userform that will close the current form and excel app and open a specific workbook in a specific directory. For the sake of development, the dummy workbook to be opened upon click is located in a folder on my desktop for now.

Now, each time I click the commandbutton, it DOES close excel and it does open the new workbook. However, the userform with the commandbutton remains frozen with an hour glass. After a few moments the error returns: Excel waiting for another application to complete an OLE action.

To eliminated the error dialogue box, i added the string: Application.DisplayAlerts = False.

Yes, that got rid of the dialogue box, but it still hangs up.

Here is the code I have for the commandbutton:

Please Login or Register  to view this content.

That seems to be worse now. I looks like it is closing excel before it can even execute the next command. Right now the next workbook doesnt even open and the current workbook crashes.

Is the OLE action that the error is referring to the previous instance not closing?

The purpose of this design is so that I have one workbook that acts primarily as a manager or other workbooks. In this scenerio, the first workbook allows the user to select an entirely independent workbook, have it load, edit it, save as, and then be able to go back to the workbook manager.

The workbook in the filepath above "NEW BLANK SCHEDULE" is a workbook saved in a program directory. When the user accesses this workbook they are immediately prompted to "SAVE AS" so they do not edit directly onto NEW BLANK SCHEDULE.