Solved: A "Browse" option for File Save?

[tccmdr]

:clever: Gurus,

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

[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 (http://vbaexpress.com/kb/getarticle.php?kb_id=284).

[lucas]

Following on Bob's suggestion. Change the Z:\Temp part to reflect the directory where you wish to start browsing:
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

[tccmdr]

:clap: Thank You Gurus:clap: