PDA

View Full Version : Solved: A "Browse" option for File Save?



tccmdr
07-11-2007, 04:52 AM
: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
07-11-2007, 05:09 AM
Look at GetSaveAsFilename in VBA Help.

Ken Puls
07-11-2007, 08:59 AM
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
07-11-2007, 09:16 AM
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
07-11-2007, 04:29 PM
:clap: Thank You Gurus:clap: