View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith[_18_] Keith[_18_] is offline
external usenet poster
 
Posts: 8
Default Project Still Open When Workbook is Closed

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?