Start here
http://www.rondebruin.nl/copy6.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Colin Hayes" wrote in message ...
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.