The code below works perfectly in converting a cell range into a PDF and automatically saving it to a specified location on a network drive.

How would I so somthing similar, but instead of saving a PDF file, it saves it as an excel file using the same naming scheme?

Please Login or Register  to view this content.