Batch process csv files

[Suryaprakash]

Hi Folks:

I have several files in D:\Folder3 and I wish to delete column N:P and rows 15:38 and then save the files as .xls in the same folder. All files have only one sheet and I use excel 2000. Any solution?

Thanks

 

[dk]

Your first step would be to record a macro where you do this for one file. Then when you've got that you can add the code to loop through all files in a folder. There are plenty of examples on this board that show you how to do that e.g. http://www.mrexcel.com/forum/showthread.php?t=350218

HTH
DK

 

[Suryaprakash]

Recording a macro is not a problem but the real problem for me is in naming the file. The file should take the name of the same (ACTIVE) file. For example, Ashok.csv should become Ashok.xls, Vijay.csv should become Vijay.xls and so on. When I record the macro for one file, say Ashok.csv and name it as Ashok.xls, the subsequent files also take the same name that is, Ashok.xls when I loop the files.

I want a syntax that the SaveAs should take the name of the ACTIVE FILE. Looping the files will not be a problem as I have got a macro for that. Putting commands for deletion of columns and rows is also not a problem. The real problem is naming the output file. Hence this request.

Regards.

 

[wigi]

The real problem is naming the output file.

But you use the Left function to take all but 4 characters out of the file name. So basically everything except the .csv at the end. Then add (hardcoded for instance):

... & ".xls"

 

[Suryaprakash]

Hi Wigi:

I tried your suggestion but could not do it right. In fact, I am not very conversant with VBA and trying to learn step by step by trial and error.

Could you give me the complete sentence for saveas command.

 

[wigi]

What is the SaveAs that you now have?

Did you step through the macro with F8 and inspecting the contents of variables? You can also use Msgbox or Deug.rint to output the contents of variables on screen.