Thanks, but how does this work in VB (excel macro)?

"joel" wrote:


Below is the method using the Win32 DLL. If htis can't get what you are
looking for then you would have to create you own listbox and put the
w\items you are looking for into the list box.

Here is the microsoft website library definition.

'SHBrowseForFolder Function ()'
(http://msdn.microsoft.com/en-us/libr...15(VS.85).aspx)

There is a paragraph in the above website the talks about SHORTCUT.


Private Type BROWSEINFO
hOwner As Long
pidlRoot As Long
pszDisplayName As String
lpszTitle As String
ulFlags As Long
lpfn As Long
lParam As Long
iImage As Long
End Type

Private Declare Function SHBrowseForFolder Lib "shell32.dll" Alias _
"SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) _
As Long

Sub test()

Dim bi As BROWSEINFO
Dim dwIList As Long

dwIList = SHBrowseForFolder(bi)

End Sub


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149959

<a href="http://www.thecodecage.com"Microsoft Office Help</a

.