For Each WB In Workbooks
Debug.Print WB.Name
Next WB

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dan" wrote in message
...
Hello
What code would I use to loop through all open workbooks, or all files in
a dir names filex****.
Thanks!