Is it really possible and is there any way to create a batch file or a VB script that could open the .csv file and then run the macro. Actually there are certain doubts that are going around in my mind. I do have a Computer Aided Software which produces a .CSV file. What I did is recorded the Macro which use to in turn cleans up the file smoothly as those created files were too basic and simple. The macro was so simple that I am able to run it without any interruption on different .csv files.
As far as I know the batch files are never able to have a switch that is capable of running a script. No doubt that the batch file somehow opens the file and also manages to run the macro manually. But still there are certain things that are beyond my understanding so please help and let me know what I should do.