Prev: Personal Macro Workbook
Next: macro based on text or number
From: MSPKELLEY on 12 May 2010 12:00
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!
From: JLGWhiz on 12 May 2010 15:17
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.



"MSPKELLEY" <MSPKELLEY(a)discussions.microsoft.com> wrote in message
news:2F2E8DFD-8F62-4A57-AB5A-868CC1E3D0B9(a)microsoft.com...
>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!


 | 
Pages: 1
Prev: Personal Macro Workbook
Next: macro based on text or number