I have some code that creates a new text file. Is there
any way to implement a browse directories were the user
can select where the file is saved to?

Something similar to the windows default save as window.

Thanks in advance.

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/

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/

.

-----Original Message-----
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/

.

.