Is there a way to loop through all the sheets in an excel workbook without indexing them through there names?
Found the answer to my question.
Using the output workbook variable in the application scope, there is a method is the workbookaplication variable type called .GetSheets(x) where x is the sheet number.
You are right GetSheet(x) works.
Anil_G
Yoichi
postwick
Shiva_Nikhil
yikwen.goo
vishal.kp
adiijaiin
LAKSHMI_NARAYANA_PEMMASAN
suraj_gaikwad
smrutismita.samal