Hello!,

A simple macro opens a form with

-a simple text input box (which ask for a file) i.e. the default path
and

-a command button which starts a macro.

Private Sub Workbook_Open()

myForm.Show

At the end of the macro I'd like to change the default value for the
text input box with the text (path) the user entered and save the file.
I can't do that.

Even if I save the Excel file with the diskette icon (after changing
the value) or Activeworkbook.save , the next time I start the Excel the
input box of the form has still its original default value.

Where did I wrong?.

Thanks,

Ale.