I have about 1000 excel files in a folder. I am looking to be able to open them, one bby one, with a VBA program so that I can alter some data(delete col and or rows) etc. and then save the file, close it, and then open the next file in the folder, make the changes etc. until all the files have been worked on.
Is there any way to do this in VBA rather than have to open each file manually, run the VBA that will make the changes, then save and close manually until all are done?
I would also like to change the files name, but if that makes the program too difficult, I can manage withouot that.
Thanks
You guys, and gals(I'm sure there is a Mrs.Excel somewhere) are the best.
Kenman
Is there any way to do this in VBA rather than have to open each file manually, run the VBA that will make the changes, then save and close manually until all are done?
I would also like to change the files name, but if that makes the program too difficult, I can manage withouot that.
Thanks
You guys, and gals(I'm sure there is a Mrs.Excel somewhere) are the best.
Kenman