On Wed, 18 Feb 2009 00:15:44 -0500, "Gary Keramidas"
wrote:

this should save it to whatever name you give it, if that's what you want.
you'll need to supply the path, too.

activeworkbook.SaveAs "YourFilename.xls"

Obviously I wasn't clear enough on my original post. :-(

I want the user to select the path but the new file name is fixed and
is different from what the currentl workbook is.

My co-worker, who will also be using this macro, likes to save files
to her desktop, while I like to put items in My Documents. So I want
to use the save as so that each of us can can pick the location that
matches our preferences. The file name needs to be different from the
current name because this is actually one part of a multi part
operation and after each step the current contents of the workbook are
saved under a different filename. I did all the development work on
this macro and set it up to save the resulting files to My Documents
and it wasn't until today when I shared it with my co-worker that she
asked "can it save to my desktop?".



John Keith