adding a bowse button to a form 8

[WaltLukeIII]

I have a form that imports an excel spreadsheet and I want to add a browse Button to the form does anyone know how to do this<br>

 

[mesavage]

Oh that works wonderfully! Thanks! )

Miriam

 

[thegentleman]

All,

Do you know of a variation of the code supplied by oharab that will return a whole directory path without having to select a file? I need to create a browse button for the user to select a directory location for the automatic creation of a new database. The above code requires the user to select a file.

All help would be greatly appreciated!!!

Regards

tg

 

[oharab]

Some more code for you tg! This calls the browse for folder dialog:

'************** Code Start **************
'This code was originally written by Terry Kreft.
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.
'
'Code courtesy of
'Terry Kreft

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 SHGetPathFromIDList Lib &quot;shell32.dll&quot; Alias _
&quot;SHGetPathFromIDListA&quot; (ByVal pidl As Long, _
ByVal pszPath As String) As Long

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

Private Const BIF_RETURNONLYFSDIRS = &H1
Public Function BrowseFolder(szDialogTitle As String) As String
Dim X As Long, bi As BROWSEINFO, dwIList As Long
Dim szPath As String, wPos As Integer

With bi
.hOwner = hWndAccessApp
.lpszTitle = szDialogTitle
.ulFlags = BIF_RETURNONLYFSDIRS
End With

dwIList = SHBrowseForFolder(bi)
szPath = Space$(512)
X = SHGetPathFromIDList(ByVal dwIList, ByVal szPath)

If X Then
wPos = InStr(szPath, Chr(0))
BrowseFolder = Left$(szPath, wPos - 1)
Else
BrowseFolder = &quot;&quot;
End If
End Function

'*********** Code End *****************
----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[thegentleman]

In the words of my mother: &quot;Perfek&quot;

Cheers oharab.

tg