View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_14_] Neil[_14_] is offline
external usenet poster
 
Posts: 29
Default Sorry. I see how to use these functions now.



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

.

.