SaveNClose

[leighmills33]

Hello everyone i have this formula,

Please Login or Register  to view this content.

how do i adapt this formula so that i can save in a desired location?
And also can i only print the whole workbook as i would like to save just 1 sheet

thanks in advance

Leigh

[Leith Ross]

Hello leighmills33,

Is the workbook being saved a new workbook or one that has been saved previously?

Sincerely,
Leith Ross

[leighmills33]

It is a default workbook, so when it has been adapted i then want a different copy saving in a new location