Dynamic Worksheet Names

[beattheswiss]

I get daily reports that always bear the same name. Until I open them, that is. At that point, both file&sheet get a sequential number. I run macros on these sheets, so the dynamic names get in my way. Does anyone know how to either
a) eliminate the numbering, or
b) get macros to perform on dynamic worksheet names?
Cheers beat

[Rubeus_Hagrid]

Hi,

Can we use the index number property for worksheets ?

e.g.

Please Login or Register  to view this content.

the above code will show the index numbers no matter what is the name of the sheet.

[beattheswiss]

Thanx Rubeus! I tried to run this macro on various worksheets and received messages like the attached one. Sorry, but I'm not getting it...
Can you explain me a little more about this code please?

[BigBas]

He just wrote a sample set to demonstrate how excel stores worksheet names. In his case, he showed that the index of a worksheet is one. That means it is the first worksheets sequentially in your workbook.

So, in excel vba, you can use the various methods to reference a sheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you need more directed responses, we'd need to see a copy of the workbook.

[Charlize]

Rewrite your code by using

Please Login or Register  to view this content.

.

Charlize

[beattheswiss]

Dudes, this is excellent - my problem is fixxxed!! Thanx ever so much!