How to active a folder that is already opened using VBA?

**mekha** · 12-30-2013, 11:02 PM

I want to open a specific folder say -
Shell "explorer.exe " & "N:\Common_Operational\Investigation Report\", vbNormalFocus
But if this folder is previously opened, then do not reopen the folder but just display the opened folder to the user.
Can anyone help me to do this?

**JBeaucaire** · 12-31-2013, 01:48 AM

Something like this:

Please Login or Register  to view this content.

**LonesomeJoe** · 12-31-2013, 01:07 PM

JB; I ran your suggested code, and it does open the Windows Explorer file (after I changed Wnd.Name to "Microsoft Internet Explorer"... I have no idea why, but that's the name Microsoft Windows XP uses for Windows Explorer). However, I can't get it to recognize the Folder if it is already open. I believe this is because the Wnd.Document.Folder.Self.Path is not a string, i.e. no quotes, while strFolder is a string. Is there a way I can change the value of Wnd.Document.Folder.Self.Path to a string? Thanx.

LonesomeJoe

**JBeaucaire** · 12-31-2013, 07:35 PM

Wnd.Document.Folder.Self.Path is a string.

File Explorer and Windows Explorer are the Windows objects that use the Self.Path for local directory listings. If you're using Internet Explorer instead of File Explorer, that won't work. I don't have first hand practice detecting the URLs currently displayed in a browser, but it's probably not rocket science.

Perhaps: http://msdn.microsoft.com/en-us/library/ms970456.aspx
..check out using the LocationURL... that looks promising.