Prev: LINECOLOUR CHANGE IN EXCEL WORKSHEET?
Next: how do you have the headings scroll down the page as you move dow
From: Colin Hayes on 15 May 2010 20:28

Hi

I need some help with some VBA code.

My workbook has 50 sheets. Numbered 1 - 50.

I'd like to have a macro save each sheet as a separate file to a path
and in a format specified by response to a popup.

Can someone assist with this?

Grateful for any help.
From: Ron de Bruin on 18 May 2010 13:50
Start here
http://www.rondebruin.nl/copy6.htm

--

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



"Colin Hayes" <Colin(a)chayes.demon.co.uk> wrote in message news:UweOtKA9wz7LFw$O(a)chayes.demon.co.uk...
>
> Hi
>
> I need some help with some VBA code.
>
> My workbook has 50 sheets. Numbered 1 - 50.
>
> I'd like to have a macro save each sheet as a separate file to a path
> and in a format specified by response to a popup.
>
> Can someone assist with this?
>
> Grateful for any help.
 | 
Pages: 1
Prev: LINECOLOUR CHANGE IN EXCEL WORKSHEET?
Next: how do you have the headings scroll down the page as you move dow