Sheet Selection

[cstimart]

I have a workbook that I will be opening to extract data, and the specific tab I want will have a specific name with some date included. (i.e. Numbers 06.01.11)

Is it possible to select that sheet using "Numbers*" or some other fashion?

 

[VoG]

Maybe like this

For i = 1 To Worksheets.Count
    If Worksheets(i).Name Like "Numbers*" Then
        Worksheets(i).Select
        Exit For
    End If
Next i

 

[Norie]

Is it the only worksheet with a name that begins Numbers?

Something like this might work.

Dim ws As Worksheet
Dim wsNum As Worksheet
 
For Each ws In Workbooks("NameOfWorkbookYouOened")
      If ws.Name Like "Numbers*" Then
            Set wsNum = ws
      End If
Next ws
 
wsNum.Select

You could add Exit For after the Set part if there are a lot of worksheets in the opened workbook.

I've included the Select to show how you could select the worksheet

You shouldn't need to do that though since you have a reference, wsNum, to it
and you can use that in the later code.