Chapter 6 Application Programs
Example Program for Excel 97
139
6
Example Program for Excel 97
7KLV#VHFWLRQ#FRQWDLQV#WKH#H[DPSOH#SURJUDP#ZULWWHQ#XVLQJ#([FHO#0DFURV#+9LVXDO#
%DVLF
#IRU#$SSOLFDWLRQV,#WR#FRQWURO#\RXU#+3#(6966$#RU#+3#(6967$1#:LWK#([FHO#
\RX#FDQ#WDNH#WKH#YDOXH#RI#D#FHOO#LQ#D#VSUHDG#VKHHW/#VHQG#LW#WR#WKH#SRZHU#VXSSO\/#
DQG#WKHQ#UHFRUG#WKH#UHVSRQVH#RQ#WKH#ZRUNVKHHW1#7KH#H[DPSOH#RQ#WKH#IROORZLQJ#
SDJHV#FKDUDFWHUL]HV#D#FRPSRQHQW#DFURVV#WKH#WHUPLQDOV#RI#WKH#SRZHU#VXSSO\1###
7KLV#H[DPSOH#UHDGV#44#YROWDJHV#IURP#D#ZRUNVKHHW/#SURJUDPV#WKH#SRZHU#VXSSO\#
WR#WKDW#YROWDJH/#DQG#WKHQ#UHDGV#WKH#FXUUHQW1#7KH#YDOXH#RI#FXUUHQW#LV#UHFRUGHG#
QH[W#WR#WKH#YROWDJH#RQ#WKH#VSUHDG#VKHHW1
Example 7KH#IROORZLQJ#WDEOH#VKRZV#WKH#UHVXOW#RI#WKH#H[DPSOH#SURJUDP#VWDUWLQJ#RQ#SDJH#
46<#IRU#FKDUDFWHUL]LQJ##D#GLRGH1#++3#3DUW#QXPEHU=#4<3404547/#0DQXIDFWXUHU#3DUW#
QXPEHU=#085493/#0RWRUROD
#&R1,
program result