hi ramana, Thnx, for ur help, but if u go through my post, u can see i have already done this ContentType method, but the problem is it will come as a single sheet, what i need is that each of the page i select should come in different excel sheet, Please see if you could do anything in this regard.