Solved: A "Browse" option for File Save?

[tccmdr]

Gurus,

Any code lying around the place that allows a "Browse" option for choosing the path you save a file to

[Bob Phillips]

Look at GetSaveAsFilename in VBA Help.

[Ken Puls]

I'm trying to remember if GetSaveAsFilename always worked... was it in existence in Office 97? Probably not an issue anymore anyway, but here is an alternative.

[lucas]

Following on Bob's suggestion. Change the Z:\Temp part to reflect the directory where you wish to start browsing:
[vba]Option Explicit
Sub a()
Dim FName As Variant
FName = Application.GetSaveAsFilename(InitialFileName:="Z:\Temp")
If FName = False Then
'Cancel
Else
ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlNormal
End If
End Sub[/vba]

[tccmdr]

Thank You Gurus