Excel used sheets

[Sathiya]

hi
i want to get the number of sheets used in excel.
can any one please help me in this regard

[Palanimurugana]

Can you loop thru all the sheet and find the usedrange.rows value for each sheet. if more than zero means u can increment the counter and get the desired from counter value

[rajpes]

i don't know if there is a method to count no of sheets in an excel file but one trick is,
try to open a non existing sheet and get that err.Number
Then in your code use a loop to open all sheets one by one meanwhile keep incrementing a variable as no. of sheets till you get that same err.number