View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default Browse Button for File Save

No I didnt mean the current workbook. I meant another
workbook called "My Stats.xls". That workbook is a
totally different workbook.


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



.