Browse Button for File Save
 

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

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

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


.

Browse Button for File Save
 

' 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

Browse Button for File Save
 

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


.