Dnereb,
Well, yes. If the OP wants to have all the bells and whistles that the
latest Excel has to offer, then Automation is the only way to go.
If only the basics with formatting etc are required then this method works
fine.
If he needs more functionality, he can always examine the BIFF file format
and expand the class.

NickHK

"Dnereb" wrote in
message ...

The older versions used the BIFF format if you search for it you can
find some VB(A) examples to read and write these files without using
Excel.
The drawback is it's version 3.0, and a lot of formatting is not
documented or possible.
It's a nice way out if someone has to create an excel file with data on
a machine without Excel.


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile:
http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396499