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,

1 Like
2

you can use an assign with Wb.Sheets.Count

1 Like
3

Hi @TimK,

Tried the same,but no luck :frowning:

1 Like
4

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

1 Like
5

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

3 Likes
6

Hey…Thanks @indra .It works perfectly

1 Like
7

great work buddy

1 Like