auto save as macro
 

Hi all, I'm working with the Office 2000 package.

Looking for advice. I have built a template that many
users can access through our network. I would like to put
a save button on it that when the user clicks it the file
automatically saves to a specific folder in their hard
drive and uses one of the fields as the file name. Also if
the folder does not exist I would like it to create the
folder.

I have done something similar with a word doc but not with
excel. Any ideas out there?

I can post the Word code if that helps.

Thanks , Kelly