Project Still Open When Workbook is Closed

[Keith]

I am having a problem where I use the command "ActiveWorkbook.Close".
For some reason it leaves the project open. By all appearances the
workbook is closed. I do not see the workbook open, and it is not
listed in the Window menu.

I am trying to clean up all loose ends where I am using both Excel &
Word macros that refer to each other. I had to play around with what
was visible and active, and think I have that in hand. (Occasionally
I will find the Microsoft Explorer is in the foreground when I am
pulling up a UserForm from Word, but it is very seldom and I am not
sure what is causing this. I can live with this.) The problem is when
I run these macros several times consecutively. Then I start getting
VBA errors on an activate command or the get command. If I close Word
and Excel, and then reopen everything it does not fix this. Any
variables I set to the application, I reset to "nothing". As I
mentioned above, my Excel project retains multiple copies of the same
project which should have closed down when the workbook was closed.

Does anybody know what I am not 'cleaning up' properly?

 

[Keith]

I forgot to mention that I can tried to delete the Excel.exe process
and sometimes this had helped. I am not sure if I am passed that
though. It has not been working recently so I have tried both the
Excel.exe & the Winword.exe. For whatever reason, my macros
definitely do not like it when I delete the Winword.exe process. I
start freezing on the get command to open the Word application.

I am finally forced to reboot, and then everything works fine & I
start all over.

 

[Keith]

I just completed a reboot and ran the macro.
1. When I ran the Excel macro, it opened the Word application then a
document, then made Excel not visible, and ran the Word macro. This
macro starts off by asking for user input from a UserForm. All I saw
was the Microsoft Explorer while the Word application and UserForm was
hidden behind this.
2. When I reopened Excel after everything was done, I get the message
"Personal.xls is locked for editing." (This is where my macro is
stored.)

As I keep playing with commands I get different items at different
times, so I am not sure what the issues are.