Does Excel have command-line options?
It would be handy if I could tell Excel to open a file and resave it as a CSV file without making the user do it, or having to write a program to do this. Does it provide any such functionality?
This link has some of the command line options, and there's some different ones added in here.
Some good info in this post.
I don't think it can be done without a macro of some kind. There are a few ways to do it, but the simplest is just to code it into the Workbook_Open method.