Hi,
I'm trying to open a bunch of workbooks from microsoft Teams with the same name, then use a for loop with workbook object to rename them without having to do it all manually. All these files are named variable_1.csv, but are from different years from different companies. I need to change them to .xlsx files and increment their number value ie. variable_1 book1.xlsx, variable_1 book2.xlsx etc.
I just get an error when trying to open multiple workbooks of the same name
any advice?
Thanks
I'm trying to open a bunch of workbooks from microsoft Teams with the same name, then use a for loop with workbook object to rename them without having to do it all manually. All these files are named variable_1.csv, but are from different years from different companies. I need to change them to .xlsx files and increment their number value ie. variable_1 book1.xlsx, variable_1 book2.xlsx etc.
I just get an error when trying to open multiple workbooks of the same name
any advice?
Thanks