I read a number of posts, all providing good hints but not sufficient for my needs.

I have a number of xls files that where the secont tab is aways named in the same way.
Files can be saved in different locations and not all the time all of them require actions (i.e. old versions, when collegues with right forget to archive them).
I would like to:
1) open all files I am interested into
2) run a macro to copy the specific tab name into the file where macro is created, file by file
3) avoids conflicts on namings, since all source tabs have same name

any valuable suggestion is more than appreciated.
tks
s

EggHeadCafe - Software Developer Portal of Choice
DOING STATIC IN C#
http://www.eggheadcafe.com/tutorials...atic-in-c.aspx