Print to PDF in specific location and file name

[frankday]

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

[ranman256]

put this code into your PERSONAL WORKBOOK, so it works for any workbook.
assign your folder to the kDIR

Please Login or Register  to view this content.

or did you mean the PDF file?