Select sheet in Excel without knowing the name.

[Kraig K]

I can't seem to get this to work. I want to manipulate data on an Excel sheet and I don't know the name of the sheet. If I rename the sheet to "Sheet1" it works fine but otherwise no.

This reports the name correctly:

Print objExcel.ActiveSheet.Name

But then this code doesn't work:

i = 1
Do
   GetCount = .Cells(i, 2)
   i = i + 1
Loop Until GetCount = ""

It says method "Cells" failed. As you can see, I'm trying to find out how many data points are in a column, if someone has an easier way...

The test data I have currently only has one sheet, what if I had more than one?

[Matias]

i = 1
Do
   GetCount = .Cells(i, 2)
   i = i + 1
Loop Until GetCount = ""

Try objExcel.ActiveSheet.Cells(i,2) instead of .cells(i,2)

[Kraig K]

i = 1
Do
   GetCount = .Cells(i, 2)
   i = i + 1
Loop Until GetCount = ""

Try objExcel.ActiveSheet.Cells(i,2) instead of .cells(i,2)

OK, it works. But I've done quite a bit of Excel manipulation and never had to do it that way before, must be becasue of the ambiguous sheet names?

Now what if I have more than one sheet? I may never, but might as well ask now just in case.