Thanks for the reply,

the problem is that I have a very large excel file (mainly because of
the formats), and I have to choose the biggest one, trying to reduce
them.
The file has more than 300 sheets, so the "manual" saving as a sole
sheet is not feasible. That is the reason why I have to get a
algorythmical solution in code (the savings requires lots of time).


--
Tamas Nagy
------------------------------------------------------------------------
Tamas Nagy's Profile: http://www.excelforum.com/member.php...o&userid=28000
View this thread: http://www.excelforum.com/showthread...hreadid=475020