I have built a survey that functions much like a webpage. The first page
will create a unique subject number and place it into worksheets called
answers1, answers2 and answers3 which the user will never see.



Each worksheet is hyperlinked to the previous worksheet and the next
worksheet. What I would like to do is two things.



1) Automatically save the worksheet based on the subject number which
was created and stored in the worksheet named Answers1 in cell A1. I would
like this to be done each time the person clicks the hyperlinked button
which takes them to the next worksheet. That way no information is lost and
each file which is returned to me has a different name which was
automatically generated.



2) I would like at the end of the survey the ability to have them click
a button, have the button save the information one last time and then close
excel.



Any ideas?