How To Read Sheet Name Of uploaded excel File

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Manesh Pawar
    New Member
    • Sep 2010
    • 15

    How To Read Sheet Name Of uploaded excel File

    Hello,
    I a now Porting a data from Uploaded Excel File to database. In that, I need to check "Sheet name" Of that Excel file Whether it is Sheet1 or Sheet2 or something else...
    Will You Please Tell Me how to Check/Read Excel Sheet name at runtime..

    Thanking you
  • danp129
    Recognized Expert Contributor
    • Jul 2006
    • 323

    #2
    Code:
    Dim sheet As Worksheet
    For Each sheet In ActiveWorkbook.Sheets
        msgbox sheet.name
    Next
    
    'or
    For i = 0 To ActiveWorkbook.Sheets.Count - 1
        MsgBox ActiveWorkbook.Sheets(i).name
    Next
    
    'or
    msgbox ActiveSheet.name

    Comment

    Working...