Renaming tabs

[MSPKELLEY]

I am running monthly financials in FRX and creating worksheets into excel.
The starting names are different for each property but the tabs need to have
the same names. Is there anyway to write a macro by placement of tab to name
the tabs in each separate worksheet over and over again each month?

There are 7 tabs in the final worksheet.

Thanks!

 

[JLGWhiz]

There would logically need to be some difference in the Sheet (Tab) name to
avoid confusion in formulas and code. But you could, once you file transfer
is completed run a short macro to name the sheets.

Set wb = Workbooks("Somename.xlx?") 'Use actual Name and extension.
For i = 1 To wb.Sheets.Count
wb.Sheets(i).Name = "Samename" & i 'Use actual sheet name.
Next

This would be the same name except that it would number the sheets
consecutively.