Quote:
Originally Posted by missinglinq
APIs aren't really my thing, but this code appears to be very old (Copyrighted 1996) what version of Access are you using and what OS?
Linq ;0)>
Hi
You could always use the FileDialog object, something like this
-
Function SelectedFile() As String
-
Dim fDialog As FileDialog
-
-
Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
-
With fDialog
-
If .Show = 0 Then
-
SelectedFile = ""
-
Else
-
SelectedFile = .SelectedItems(1)
-
End If
-
MsgBox SelectedFile
-
End With
-
-
End Function
-
??
You need a referance the Microsoft Office Object Library.
MTB
