Setting up a macro/batch file to perform a few tasks

[vitalym]

I am looking to create a macro or batch file that does the following:

1. Extract a csv files from a .bz2 archive
2. Import the csv into Excel as a text file along with some specific settings during importing
3. Apply a formula to the imported columns and place the value in a new column
4. Save the file as .xls

While this takes a few minutes to do, I will need to do it very frequently and a macro would help greatly.

Is any/all of this possible to setup as a automated process?

 

[Snowknight26]

I doubt 2-4 are possible with the literal definition of a batch file. Seems like you'd need help from a program that can interact with Excel (using the Excel COM in C#/VB.NET, for example).