When collecting new links to publish in my Excel Super Links series, I try not to reuse the link in another article. I have been using Windows Explorer (with Windows Indexing enabled) to search the folder where I store these files and look for any files that might contain that link in order to prevent this from occurring. What I wanted was a way to access the File Explorer from the Excel environment. The following procedure performs this task very nicely.
Function WinExplore(TheFolder As String)
On Error Resume Next
Shell “Explorer.exe ” & TheFolder, vbNormalFocus
This function can be entered in a worksheet cell and when recalculated will open Explorer at the desired folder.
I hope that you find this useful.