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

Try this one
http://www.rondebruin.nl/copy6.htm

--

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


"umpire_43" <(E-Mail Removed)> wrote in message news:C2200DE0-62AC-4949-8C07-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message news:C2200DE0-62AC-4949-8C07-(E-Mail Removed)...
> > 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
>