I have a macro that asks the user for their name and email address during
execution.

How can I save this information so that they don't have to reenter it every
time they run the macro on a new spreadsheet? There's no point in saving it
to the current spreadsheet, as every time they run the macro, it's on a new
spreadsheet.

Can I store the information to PERSONAL.XLS, then automatically save
PERSONAL.XLS so they don't get prompted when closing Excel, and then go get
their hat information the next time they run the macro on a new spreadsheet?

Thanks!
Dee