I have examined these functions. This is what the
GetSaveAsFilename does, "Displays the standard Save As
dialog box and gets a file name from the user without
actually saving any files."

I need to save a file and want the browse capability.

-----Original Message-----
have a look at GetSaveAsFilename & GetOpenFilename



fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Text Files (*.txt), *.txt")
If fileSaveName < False Then
MsgBox "Save as " & fileSaveName
End If


---
Message posted from http://www.ExcelForum.com/

.