Changing same data, different cell in multiple excel files

Question

Hi

I am trying to figure out how to change data in multiple excel files.

Each cell contains the same information in each file, however, the cells do not have the same cell number.

I had tried uploading each and every file into Access changing it in there, but when it came to exporting the files individually the entire sheet was exported into one file. Importing multiple files into Access has been time-consuming.

Thank you for your time.

Answer 1

You can loop through thousands of files - opening each, changing whatever needs to be changed, the saving and closing it.  If the data being changed is in different locations, then you would just need to use some logic in the code to find it.  So, can you describe the logic (sheet and cell logic, if needed)? Also, explain the logic for choosing which files need to be changed (select the files, process a folder of files, process files by naming convention, etc.).