Excel Sheets and VB

[camaro77]

I have activated the worksheet that i am trying to get to in Excel. However, VB will recognize the default worksheet and will not read any values from the activated worksheet. All the worksheets are located in the same workbook. Code is as below:

Workbooks(lateruse).Sheets(excelinfo3).Activate
'Later Use is the C:/ Filename** 'EXCELINFO3 is the SHEET NAME'
ActiveWorkbook.Worksheets(excelinfo3).Activate

'EXAMPLE DO FOR LOOP TO SEE IF VB SEES NEW SHEET
Do Until InStr(Excel1.Cells(row, col), "Group")
a = Excel1.Cells(col, row).Value
row = row + 1
Loop
'EXCEL RETURNS DEFAULT SHEET VALUES

HELP!!

Thanks in advance!!
~Jason

[JordanChris]

'PURPOSE: This will Open myfile.xls, and the particular worksheet
  appExcel.Workbooks.Open FileName:="C:\myfolder\myfile.xls"
  appExcel.Worksheets("pSheet").Select
'PURPOSE: This will send data to a particular Range
  appExcel.Range("A4").Value = "help me"