sub listWS
Dim ws as Worksheet
for each ws in Workbooks("YourWB").WorkSheets
msgbox ws.Name
next ws
end sub

HTH
--
AP

"Gian" a écrit dans le message de news:
...
Hi,

How can I get all the worksheet name from another opened workbook?

Thanks.

gian