View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_3_] Rob van Gelder[_3_] is offline
external usenet poster
 
Posts: 6
Default Browse Button for File Save

strFileName = Application.GetSaveAsFilename

"Todd Huttenstine" wrote in message
...
Hey guys,

I have a userform that contains a button and a textbox. I
want to make that button a browse button so that when a
user clicks it, it brings up a file tree with a Save and
Cancel button.

I want the user to be able to browse in each directory and
when they click save, the program save whats in the
textbox to that directory.


Thanx

Todd Huttenstine