Excel Sheet names

[George1111]

I am accessing an Excel Workbook with sheet names which are not called Sheet1, Sheet2, Sheet3 using VB6. Rather, they are called something else and there may be more than only 3

How can I establish the actual names in the Workbook using VB6 ?

Thanks

[mudraker]

As this is an Excel forum I can not tell you exactlyhow to do it in VB6

This is one way in Excel VBA

Please Login or Register  to view this content.

[George1111]

Thanks for such a quick reply - I'll follow that path

Cheers