We are mainly a UNIX environment so need processes that we can automate in a non-gui world, even if it has to be in a Microsoft environment. Basically we need to set up an automated process in which we can receive an excel spreadsheet, run a batch file which calls excel with a macro to extract certain data and create an output file that we can then use in our UNIX environment (preferably delimited ASCII).
The piece I need help with is how to run some macro (if that is what I need to do) from a batch file or command line, that will take as arguments an inputfile and an output file. The input file is an excel spread sheet the output file is ASCII data that I need to extract from the excel spreadsheet.
Once I have this I can get it back into the UNIX world no problem and be able to further process it as needed.
Your help is appreciated,
Tony