Thanks Sergey ... worked like a charm but I do have one more question. If you didn't know the name of the worksheet (tab) what is the reference to the "name" that is stored in the tab so I can pull the extract name.

>lcSheetName = "Whatever"
>oExcel.Sheets(lcSheetName).Activate()
* or
>lnSheetNumber = 2
>oExcel.Sheets(lnSheetNumber).Activate()

>I haven't done much with "automation" by am a somewhat familar with the basics but I can't seem to figure this out.
>
>How do you change the "activesheet?" For example, if I add three worksheets how to I switch back and forth between the thee worksheets, thus making #1 the activesheet and then #2 the activesheet and then #3 the activesheet, etc.
>
>Robert Wright