Kumar Salui
New Member
Hello, I have 150+ excel files in one folder. Each file is having ten worksheets. I need to open up all excels and do some data manipulation from 10 sheets to create three new worksheets in each of the excel files. I have created the code for data manipulation and creating three new worksheets and dealing older ones for one individual sheet. Now I have to automate this for all 150+ files.
Can you please share an example code on how to open up each excel (.xlsx) file from a list located at an external .xlsm file, run the above code (you can just show one-line code for testing purpose), and then "save as" with a new file name? I am attaching the .xlsm file. Thank you!
Can you please share an example code on how to open up each excel (.xlsx) file from a list located at an external .xlsm file, run the above code (you can just show one-line code for testing purpose), and then "save as" with a new file name? I am attaching the .xlsm file. Thank you!