<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>myOffice Email Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content=2002-11-01 name=date>
<STYLE type=text/css></STYLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2>We have always used the Excel OLE
object.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><SPAN
class=971474723-23012006><FONT face=Arial color=#0000ff size=2>LExcel :=
CreateOleObject('Excel.Application');</FONT></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2>You can access the sheets, and modify cells
directly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=971474723-23012006><FONT face=Arial
color=#0000ff size=2>Stacey</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Gary T.
Benner<BR><B>Sent:</B> Tuesday, 24 January 2006 11:37 a.m.<BR><B>To:</B>
delphi@delphi.org.nz<BR><B>Subject:</B> [DUG] Excel - best
practice<BR></FONT><BR></DIV>
<DIV></DIV><SPAN style="FONT-FAMILY: MS Sans Serif">HI guys,</SPAN>
<P><SPAN style="FONT-FAMILY: MS Sans Serif">Just having to ease back into some
coding accessing and modifying an Excel spreadsheet.</SPAN>
<P><SPAN style="FONT-FAMILY: MS Sans Serif">Was wondering what components are
best to use to achieve this. Did some preliminary work with ADO but had flaky
results in the modification side.</SPAN>
<P><SPAN style="FONT-FAMILY: MS Sans Serif">Your ideas welcome!!</SPAN>
<P><SPAN style="FONT-FAMILY: MS Sans Serif">kr</SPAN>
<P><SPAN style="FONT-FAMILY: MS Sans Serif">Gary</SPAN>
<P><FONT face=arial color=navy size=1></P>
<DIV style="WIDTH: 260px; HEIGHT: 50px">
<MARQUEE id=marquee1 style="WIDTH: 260px; HEIGHT: 200px" trueSpeed
scrollAmount=5 scrollDelay=20 direction=right behavior=slide loop=1 border="2">
<HR>
<TABLE>
<TBODY>
<TR>
<TD><FONT face=helvetica,verdana,arial color=black size=4>Gary Benner
</FONT></TD></TR>
<TR>
<TD><FONT face="arial, arial, helvetica, sans-serif" color=black
size=2>e-Engineer, Lecturer, and Software Developer</FONT></TD></TR><BR>
<TR>
<TD><FONT face="arial, arial, helvetica, sans-serif" color=#000099
size=2><B><A style="COLOR: blue; TEXT-DECORATION: none"
href="http://www.123.co.nz">123 Internet Limited</A></B></FONT></TD></TR>
<TR>
<TD><FONT face="arial, arial, helvetica, sans-serif" color=#000099
size=2><B><A style="COLOR: #993333; TEXT-DECORATION: none"
href="http://www.waiariki.ac.nz">Waiariki Institute of
Technology</A></B></FONT></TD></TR>
<TR>
<TD><FONT face="arial, arial, helvetica, sans-serif" color=#cece00
size=2><B><A style="COLOR: #cece00; TEXT-DECORATION: none"
href="http://www.sunshinebags.co.nz">Sunshine Garden Bag
Co.</A></B></FONT></TD></TR>
<TR>
<TD><FONT face="arial, arial, helvetica, sans-serif" color=red
size=2><B><A style="COLOR: red; TEXT-DECORATION: none"
href="http://www.sommnet.com">Sommnet.com Limited</A></B></FONT></TD></TR>
<TR>
<TD><FONT face='22helvetica,verdana,arial"' size=1>Mob: 021 966
992</FONT></TD></TR>
<TR>
<TD><FONT face=helvetica,verdana,arial size=1>Email: <A
href="mailto:gary@123.co.nz">gary@123.co.nz</A>
</FONT></TD></TR></TBODY></TABLE></MARQUEE></DIV><BR><BR>Ref#:
41006<BR><BR></FONT></BODY></HTML>