oSheet.Name
>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
--sb--