Do you want to make a copy of the activeworkbook or
is the workbook not open ?
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"dgd1212" wrote in message ...
How would one write a macro that makes a copy of a workbook and places it in
MyDocuments Folder? The macro also needs to delete one worksheet.
Thanks