Thread: copy sheets to workbook and save as sheet name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
umpire_43 umpire_43 is offline
external usenet poster
  
Posts: 17
Default copy sheets to workbook and save as sheet name
Hi Ron,
Worked great ty

Just some fine tuning now

"Ron de Bruin" wrote:

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