Hello,

I have a new product form with 2 save as buttons on it. One is to save as a draft copy and one is to save as a final copy. I'd like to have the activeworkbook.saveas command save a copy where the filename is 2 strings joined together, one string would come from the product name cell and the other would be "draft" or "final". The filename would be something like ProductZFinal.xlsm

Thanks very much for any help