Browse Save As Feature

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

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
 
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-----
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.

.
Click to expand...
 
Back
Top