Posts by nospam

Thanks Epidemic! Looking forward to it.

-Tony

Thanks for the replies. I must I only know enough about Excel to be dangerous. A lot of that stuff I read in the replies sounds promising but please break it down into layman's terms. I just need to get the data out of an excel spreadsheet and get it into UNIX so converting an XLS spreadsheet into a CSV is fine as long as no human has to do it. Running as a task works for me.

Epidemic: you sound like you are doing much like what I need. Can you elaborate and give me a sample please.

Thanks,
Tony

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