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

1) To browse for specific files, check out the
Application.GetOpenFileName Method
2) To copy worksheets from one workbook to another, check out the
Worksheets.Copy method.
3) You could copy the worksheet, then rename it using Sheets.Count + 1
to get a unique number which you can append to the sheet name.

--JP

On Oct 7, 2:06*am, stefano canepa wrote:
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