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

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

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


.

GetSaveAsFilename puts up the File=Save As dialog. It doesn't actually do
the save, but allows the user to browse the directory and specify a file
name - then returns the fully qualified path as a string, which you can then
use to save the file. However, you said you already had a filename, so I
offered the folder browser dialog so the user knows they are only picking a
location.

--
Regards,
Tom Ogilvy


Todd Huttenstine wrote in message
...
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


.

' folder selection dialog from John Walkenbach's
' site
' http://j-walk.com/ss/excel/tips/tip29.htm

--
Regards,
Tom Ogilvy


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