Please I need a macro to save an open/active file (whole file) in a new location - "L:\Customization\QUALITY\CN's & CAR's\CN & CAR Reports 2015" - also the specific file name I want to use for the new file is the result of a formula that is located in cell "W1" on the active sheet.

Also if it's not too complicated - once the file has been saved and renamed can the macro copy cells I2:N2 on the active sheet and paste special value on top of these cells - I want to remove the formulas and relpace with the values in these cells.