Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel used sheets
#1
Not Solved Smile 
hi
i want to get the number of sheets used in excel.
can any one please help me in this regard


Reply
#2
Not Solved
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
Reply
#3
Not Solved
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Compare Two ex cel sheets and highlight differences neerukonda9 17 14,338 06-03-2020, 12:04 PM
Last Post: rajrk
  Comparing two excel Sheets whose columns names vary Divya Roopa 2 8,731 03-26-2014, 07:20 PM
Last Post: Parke
  Iteration in Local sheets for UFT11.5 haithamQTP 1 3,247 02-27-2014, 09:12 AM
Last Post: supputuri
  How to give the For Loop for 3 work sheets? Uma 1 2,978 09-10-2011, 06:54 PM
Last Post: Uma
  Why we have global and local data sheets anbarasu 1 2,259 08-19-2009, 04:09 PM
Last Post: Saket

Forum Jump:


Users browsing this thread: 1 Guest(s)