| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Project not close after file closed
I have code that opens a file and close's it as a saveas in a different
folder. Problem is that when I go into VBA code the last file that was closed it VBA Project is still open. How can it be closed and removed from the Window? Rick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Project not close after file closed
This seems to happen every so often.
It's never caused me any trouble -- but if you make changes to one of the ghost projects, you'll be wasting your time -- since the workbook isn't really there. So it can be confusing/dangerous. The only way I know to get rid of it is to close excel and reopen it. Rick wrote: I have code that opens a file and close's it as a saveas in a different folder. Problem is that when I go into VBA code the last file that was closed it VBA Project is still open. How can it be closed and removed from the Window? Rick -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Project not close after file closed
Thanks Dave:
"Dave Peterson" wrote: This seems to happen every so often. It's never caused me any trouble -- but if you make changes to one of the ghost projects, you'll be wasting your time -- since the workbook isn't really there. So it can be confusing/dangerous. The only way I know to get rid of it is to close excel and reopen it. Rick wrote: I have code that opens a file and close's it as a saveas in a different folder. Problem is that when I go into VBA code the last file that was closed it VBA Project is still open. How can it be closed and removed from the Window? Rick -- Dave Peterson |
| Reply |
| 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 | |||
| Project still in "project explorer" window after file closed down! | Excel Programming | |||
| Project still in "project explorer" window after file closed down! | Excel Programming | |||
| VBA project does not close when workbook is closed | Excel Programming | |||
Linear Mode
