Loop Through Folder - extract Wb and Sheet Names

I have tried to modify various codes with no success to :
Loop Through files in a particular folder -
Then list the workbook names for each workbook -
together with their corresponding sheets names.


Suggestions would be greatly appreciated.

This will be for Excel 2007.





Thanks
Mark

Hi max57,

Try this - just change the varaibles I've noted as "change to suit" to meet your requirements:

Please Login or Register  to view this content.

HTH

Robert