So I'm now thinking that your real question is: Hold do I open Windows
Explorer to a specific folder?

This may help if so:

Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub LaunchWinExplorer()
Dim TargetFolder As String
TargetFolder = "d:\download"
ShellExecute 0, "Open", TargetFolder, "", "C:\", 1
End Sub


--
Jim Rech
Excel MVP