Thread: copy sheets to workbook and save as sheet name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default copy sheets to workbook and save as sheet name
Try this one
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"umpire_43" wrote in message ...
Hi There,

I have a spreadsheet over 40 sheets. What i like to do is to:
1) copy each sheet into its own workbook
2) name that workbook that matchs the sheet name
3) User selects the directory where the first file is saved and saves the
directory for the rest of the sheets within the workbook
4) Closes the saved workbook that has one sheet in it

Can you help?
thanks
Reply With QuoteReply With Quote