Also, the Workbooks collection only deals with workbooks which are open in Excel. Is this what you want?


Otherwise, you would be searching the file system for .xlsx files (and xlsm and xls files?).