Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA project does not close when workbook is closed | Excel Programming | |||
VBA project does not close when workbook is closed | Excel Programming | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
VBA project does not close when workbook is closed | Excel Programming | |||
Project stays in VBEditor when workbook is closed | Excel Programming |