You can't save just a sheet to a folder so you must be mis-interpreting the
function of Ron's code.

His code probably copies one sheet from a workbook to a new workbook before
saving to a folder.

Post the URL for the code from Ron's site.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 00:00:01 -0800, chrisnsmith
wrote:

I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy
these
sheets to a new workbook?