Browse Button for File Save

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

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.
 
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.
 
Back
Top