How to copy Sheet to a new workbook and save to a specific folder

Hi,

I've been scratching my head on this problem.

I would like to copy a sheet and save it using a specific name from a range on the sheet to a specific directory or path.


The code i've been trying to edit is from Ron de Bruin but i'm having problems and debug errors once I made changes.
*Note: the code says copy all sheets to a new workbook. But i only wanted to copy one.

Please Login or Register  to view this content.