I am looking for a macro that will save a worksheet to a macro using the Date, Active WorkSheet, and Active WorkBook as a name "YYYYMMDD_WS_WB" I also want it to save it in the same location every time. Then give me a preview.

If there is anyone that could help me with this it would be great.

Thanks