How to count the number of sheets in the excel file

Help
, , ,
#1

Hi Guys,

How to count the number of sheets (sheet 1,sheet 2…sheet n) in the excel file.?
Please let me know your answers,

Thanks in Advance,

#2

you can use an assign with Wb.Sheets.Count

#3

Hi @TimK,

Tried the same,but no luck :frowning:

#4

if you can send me the sample files,that willbe great

#5

@rpadev please check attached file NextSheetExl.zip (85.3 KB)

1 Like
How to read more than one excel sheets in a for each loop
#6

Hey…Thanks @indra .It works perfectly

1 Like