B
Bishop
Dim wb As Workbook
Dim ws As Worksheet
For Each wb In Workbooks
'Test to see if wb's name is like "ExportedData*"
If wb.Name Like "ExportedData*" Then
'Create a worksheet object to reference the appropriate
'worksheet in the wb
'Why does this work...
Set ws = wb.ActiveSheet
'But this doesn't?
Set ws = wb.Worksheet("Tally sheet")
How do I make the second one work? Once I find the specified workbook I
need to select a specific sheet (Tally Sheet) in the workbook.
Dim ws As Worksheet
For Each wb In Workbooks
'Test to see if wb's name is like "ExportedData*"
If wb.Name Like "ExportedData*" Then
'Create a worksheet object to reference the appropriate
'worksheet in the wb
'Why does this work...
Set ws = wb.ActiveSheet
'But this doesn't?
Set ws = wb.Worksheet("Tally sheet")
How do I make the second one work? Once I find the specified workbook I
need to select a specific sheet (Tally Sheet) in the workbook.