So I know how to open a folder within an excel vba macro, but I want to be able to close it as well. Any thoughts? This is what I'm using to open the folder:
Shell "Explorer.exe *file path*"
So I know how to open a folder within an excel vba macro, but I want to be able to close it as well. Any thoughts? This is what I'm using to open the folder:
Shell "Explorer.exe *file path*"
You can use the Process ID, stored in
vPID
, to kill the application when you’re done with it. all you have to do is invoke theTaskKill
command with the sameShell function
.