hi,

ok, but how can I revise it for just copying the sheets without ranges ?
--
SAHRAYICEDIT-ISTANBUL


"Ron de Bruin":

See this link on the page
http://www.rondebruin.nl/fso.htm


--

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


"excel-tr" wrote in message ...
hi,

to include subfolders, what is the revised code for 11th example ?
--
SAHRAYICEDIT-ISTANBUL


"Ron de Bruin":

Hi SAHRAYICEDIT

Start here
http://www.rondebruin.nl/copy3.htm

--

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


"excel-tr" wrote in message ...
Hi,

I have lots of workbooks having worksheets in different folders.How can I
save all worksheets in different workbooks into one new workbook ?

regards.
--
SAHRAYICEDIT-ISTANBUL