Get Name List of All Open Workbook Files

[princ_wns]

hi all,

How can i get the name of all opened (excel) file . I have to list the name of all file and check whether the the file which is required by program is open or not.what should be its vba code to do this?


thanks in advance