Activeworkbook.saveas question

[MGT2000]

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

[Richard Buttrey]

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

Hi,

Just declare a variable for the filename and set the value by concatenating the product name cell and whatever else you want. So for ex. if the Product name 'ProductZ' is in cell A1, use the following in your code

Please Login or Register  to view this content.

If you want to vary the 'Final/Draft' choice then you could build in an IF..THEN test, or a CASE SELECT statement and set the stFileName variable as appropriate.

HTH