how to retrieve all sheets without knowing sheet name

[paopao000137]

Hi,

I am working on excel report parser. Though my all reports have same format, sheets' names are named differently from one report to another report by different people. So how to retrieve all sheets, one by one without knowing sheet's name? I only know

Set xlSheets = xlBook.Sheets("sheetname")---I need to know sheet name.

Many thanks

 

[Loomah]

Hi
In essence:-
dim ws as worksheet
for each ws in worksheets
do some stuff to ws
eg msgbox ws.name
next

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[paopao000137]

Hi Loomh, Thanks a lot. It works.