Ong -

It seems to me that this approach would not work unless Excel is installed on the
host machine. How else does the software activate the Excel object?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ong wrote:

Hi all,

I found that in many reporting software, they also have a built-in function
to export their report in Excel format, no matter the PC have Excel installed
or not. I searched in web and found that most of the sample code is creating
the Excel COM object (Excel.Application, Excel.Workbook etc....) and then
write their contect into each cell and finally close/release all the
reference. However, is it the way those reporting software I have mentioned
before export their report into Excel format ?
If not, how they can do that ? Is it there is some API which I can call to
achieve it ?

Thanks in advance

ong