Can Excel be controlled programmatically?

I need to have Excel read a data file, create a chart and save it as a
picture (gif, pdf).
Can I do this from the command line or using a batch file?
Do you have a document/link/example?

Thank you  in advance.
- Mike