'32-bit API declarations
Declare Function SHGetPathFromIDList Lib "shell32.dll" _
Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long
Declare Function SHBrowseForFolder Lib "shell32.dll" _
Alias "SHBrowseForFolderA"...
There are, however, certain times where it is necessary to select a different worksheet or different cells. I have found these through trial and error, usually due to some bug in Excel 97. For the examples listed below, I have found that it is necessary to select the target worksheet/cells in...