View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macro to copy a workbook and delete a specific worksheet

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