VBA Project not close after file closed

R

Rick

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
 
D

Dave Peterson

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.
 
R

Rick

Thanks Dave:

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name of file opened, being viewed 2
Can't close old pst file 2
Hyperlink fails to open on the first click 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Project - VBA Project window - Excel 2003 9
Access Lock File .LACCDB / Now shows as a notepad file 0
Set as Default Template not working 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top