Find Active worksheet after Workbooks.Opentext???

Excel 2002 SP3

I'm trying to write a set of macros to read ; text files and do some charting.

So I have Workbooks.OpenText working to open the data properly, but then I need to get a reference to the current sheet of which there is only one. But no reference that I try will work. They all toss an error '91 Object or With block not set.

After I do the OpenText and make the new workbook, then I need to call a series of subs to do format the data and do some charting. The formatting - recorded from a macro, works just fine, so I know the OpenText call leaves the new data as the active sheet, but I need an object reference to the active sheet to continue with the processing, and I can't get that reference.

The code for the first failing routine looks like this:

Please Login or Register  to view this content.

I figure I'm doing something simple and stupid, but in spite of 5 inches of books to look through I can't find a working example of what I need.

Thanks much,
ww