Dim sPath As String
sPath = "C:\HospImports"
retVal = Shell("explorer.exe " & sPath, vbNormalFocus)
The code works great. Now, I want the spath to instead be a folder like:
\\mynetwork\folder & range(d4).value
I can get the \\mynetwork\folder to work great. It doesn't like the rest, which is just a folder name that resides in cell D4.