hi all,

i have one Excel sheet contains 35 worksheets ( all are formatted ) now
i need to copy each workbook and i have to make a new excel sheet with
the individual name ( say sum,sub,mul,div these are all workbooks name
then i should be saved as same name(or sum_new something like that) for
New excel sheets) .

Currently im doing all these works by manual (Right click then select
new book then make a copy and then im saving as respective filename) .i
have to do the same daily .so can anyone help me in this ....

U can contact me thro'

Thanks in advance.

Ragavendran R

Hi Ragavendran R

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

--

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


wrote in message ps.com...
hi all,

i have one Excel sheet contains 35 worksheets ( all are formatted ) now
i need to copy each workbook and i have to make a new excel sheet with
the individual name ( say sum,sub,mul,div these are all workbooks name
then i should be saved as same name(or sum_new something like that) for
New excel sheets) .

Currently im doing all these works by manual (Right click then select
new book then make a copy and then im saving as respective filename) .i
have to do the same daily .so can anyone help me in this ....

U can contact me thro'

Thanks in advance.

Ragavendran R