asked on
Public Function GetSaveFilename(FileLoc As String) As String
Dim n as integer
Dim Dialog As FileDialog
Dim strData as string
Set Dialog = Application.FileDialog(msoFileDialogSaveAs)
n = FreeFile()
Print #n, strData
Close #n
With Dialog
.InitialFileName = FileLoc
.FilterIndex = 2
.title = "Save As"
If .Show <> 0 Then
GetSaveFilename = .SelectedItems(1)
End If
End With
En
d Function