Select Sheet in VB dot net

Anand Bohra

16y5.7k

Hi,
I am creating a excel file using VB Dot Net to fetch data from SQL.
It works well & code is 100% complete
the only problem is how to give reference to excel sheet using its name property rather than displayed name
like I am using Globals.Thisworkbook.Sheets("Database")
now my requirement is what if user changed the sheet name from Database to say DB or whatever. My code fails
I tried lot to give reference to sheet number programatically but all in vain
In VBA I used to give reference like Sheet1.select instead of Sheets("Database").select so that my code run irrespective of sheet name.

Kindly suggest me the same way in VB DOT NET
I tried Globals.thisworkbook.sheets(1)
Globals.thisworkbook.worksheets.item(1)
but all fails even if user change sheet positions.

Pl . Pl. help me its urgent

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

PJ Martins16y ago
Each worksheet contains a property CodeName. Loop through each sheet and check it's CodeName against Sheet1, Sheet2, and Sheet3.
Anand Bohra16y ago
I suppose Globals.thisworkbook.Worksheets.get_Item(1) is for C# & not VB dot net
the equivalent VB code is
Globals.ThisWorkbook.Worksheets.Item(1)
but the same is populated based on total sheets in workbook counting from left to right
so whatever sheet be in first positions will be taken irrespective of sheet name or its program name
I want to select particular sheet based on its named property rather than caption
like in VBA we use Sheet1.select instead of Sheets("ABC").select
PJ Martins16y ago
try Globals.thisworkbook.Worksheets.get_Item(1)