Programing a simple routine in microsoft excel 2007 on windowx xp -

I have minimal experience with coding tasks within software platforms (such as SPSS syntax, matpup scripts, psycho code). Because of this, I think that I congratulate myself that I can codify the normal routine loop for general programs. I hope this is a way of doing this for Excel. Specifically, there is a way I can excel the code: Open a file, delete the two columns respectively, and save that file from a new file name in a new location and repeat it for all the files in a folder ? I believe the answer to this question would be very useful for individuals with minimal coding experience, which would benefit from the code which automatically works in Excel automatically without pointing and clicking in the GUI

Turn on the Macro Recorder

Open

Open your first file

1. Open
/ Li>
2. Delete your two columns
3. File
4. Prevent the macro recorder

This will give you the necessary VBA code, then you can wrap a simple loop around it to repeat all the files in your directory.

Give it a shot, then come back with the code, if you have a problem, then you have to ask a specific question and ask.