Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel?

(PS: The office is mac version.)

share|improve this question
    
from external? from within the document? as a macro? etc etc. –  akira Sep 21 '12 at 6:35
    
@akira Within the document. No matter whether use a macro, just want to export a list of names as text. –  xdazz Sep 21 '12 at 6:57
add comment

1 Answer

up vote 1 down vote accepted

Try using the following macro:

Sub ListWorkSheetNames()

For i = 1 To Sheets.Count
Range("A" & i) = Sheets(i).Name
Next i

End Sub

For me - works quite well.

(source)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.