Worksheet Name
 

Hi,

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

Thanks.

gian

Worksheet Name
 

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