Hi ker9,
There is a command that is not on the normal toolbars called Export Range to File...
You need to customize your toolbar and add it as an icon and try it out.
I believe it has many formats it will save as.
Search the net for "Excel Export Range to File" and see how others do it.

I hope that helps.