Open all the files in a folder delete column 'A' and save the files

[SriDurga]

Hello all,
I have 10 to 15 files in a folder which needs to get updated every day.
Folder name: Summary
File names: different each time
I need to open each file, delete column 'A' and save each file.
Kindly help me with a macro to do the task.

Thanks in advance.

 

[Joe4]

There are lots of posts out there you can find if you do a Google search on "Excel VBA loop through all files in a folder".
Here is one: Loop Through all Files in a Folder using VBA

Adding the part about deleting column A is pretty trivial. You can get that part of the code by using the Macro Recorder (turn on the Macro Recorder and record yourself deleting column A in any file, and you will have the code that you need).

 

[SriDurga]

There are lots of posts out there you can find if you do a Google search on "Excel VBA loop through all files in a folder".
Here is one: Loop Through all Files in a Folder using VBA

Adding the part about deleting column A is pretty trivial. You can get that part of the code by using the Macro Recorder (turn on the Macro Recorder and record yourself deleting column A in any file, and you will have the code that you need).

Thank you so much

 

[Joe4]

You are welcome.
Glad I was able to help!