Agent Orange
New Member
- Joined
- Sep 8, 2002
- Messages
- 2
I have a browse button and I want to set my default directory, in which when i press the button it goes to that directory rather than mydocuments or some crap...Any help would be great thanks in advance.
Here is the code I am using for the browse...
[
Dim Filter As String, Caption As String, SelectedFile As Variant
Filter = "Excel (*.xls),*.xls"
Caption = "Please Select SpreadSheet"
SelectedFile = Application.GetOpenFilename(Filter, , Caption)
If SelectedFile = False Then Exit Sub
Me.destination = SelectedFile
Set SelectedFile = Nothing
]
Here is the code I am using for the browse...
[
Dim Filter As String, Caption As String, SelectedFile As Variant
Filter = "Excel (*.xls),*.xls"
Caption = "Please Select SpreadSheet"
SelectedFile = Application.GetOpenFilename(Filter, , Caption)
If SelectedFile = False Then Exit Sub
Me.destination = SelectedFile
Set SelectedFile = Nothing
]