I have a macro to extract .xlsm files from sub-folder C:|downloads on sheet2 and then to copy to sheet “Workspace” and then open these files based on the workbooks on sheet “Workspace”
I need the macro amended so that if some of the workbooks in the sub-folders does not contain a .xlsm file , then to extract and open the .xls file
I have attached a sample workbook containing my code
Your assistance in amending my code so that if an .xlsm file in not found in one of the sub-folders with C:downloads , then to extract the .xls file to sheet2 and then copy to shet “Workspace” and then open the files on sheet “Workspace
