Close Folder

**plans** · 07-05-2014, 09:28 PM

Hi,
I am trying to close an open folder using VBA.
The folder is like: c:\My Jobs\Folder to Close
What would be the code to close this?
Thank you

**6StringJazzer** · 07-05-2014, 09:38 PM

There is no concept in Windows or VBA of an open folder, only open files. (There is the idea of Windows Explorer being open to a folder, but Excel and VBA won't care or even know about that.) How did this folder get open in the first place?

**plans** · 07-05-2014, 09:47 PM

This is how I opened it:

Please Login or Register  to view this content.

**6StringJazzer** · 07-06-2014, 10:05 AM

What you have done is a shell call to Windows to open a Windows Explorer window on a particular folder. I will have to step aside on this one as I have not done shell calls in VBA. I believe there is a way to call Shell to return a process ID and then later you can go back and close that process, but I am not familiar with how it works.