C chrisnsmith Feb 14, 2009 #1 I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy these sheets to a new workbook?
I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy these sheets to a new workbook?
R Rasoul Khoshravan Feb 14, 2009 #2 I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy these sheets to a new workbook? Click to expand... A simple way could be to copy the file, name it and then delete the extra sheets you don't need.
I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy these sheets to a new workbook? Click to expand... A simple way could be to copy the file, name it and then delete the extra sheets you don't need.
G Gord Dibben Feb 14, 2009 #3 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
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
