          qTTTTTTTTTTTTTTTTTTr                            
          U     ==  Excelٱ8.0  ==     U                           
qTTTT     79ߺ26     TTTTr
U        U     ȫλĹЧ       U        U
U        tTTTTTTTTTTTTTTTTTTs        U
U                                                        U
U      qr      U
tTTT      ߣ޸վ QQ670218239        TTTs
        ts

   ˵һ                       
ũ˫ѯ߼λѡɫ޸ļʱ䡿áɫϼơݹʼ㳮ƱвС۷ֹ۷֡ϲıֵѡ򹤾ߡ䡿ɾָϸҳСơɾҳСơͼƬĿ¼ͼƬȷƥ䣩ͼƬģƥ䣩ͼƬעɾͼƬͼƬͼƬѯߡѡΪͼƬɸԻע GIFFlashֹ¼ظֵͬ벻ͬļĿ¼ȡѡظֵظֵʾظֵɾհ׵ԪСɸѡΨһֵĿ¼½ƹӽܡƽ⹤/롿 ļɻԭĺϲϲֵͬȡϲԭݡϲԶСϲѡϲݲơѡ񡿡ıַ㡿ʽǧټĸСһطʹб߱ͷӡǰҳ˫ӡɵ׶˱⡿ת塿ת塿ϵͳͼ꡿ȡ޸ExcelƽVBA롿ɾյԪ񡿡תѡеáеáĸСдתСдתддתСдݼܡơɫɸѡɫ򡿡ҳ

  Զ庯һ 
sumifcolAVERhesumNOWWSFZעϲȡΨһֵֵɫ͡ɫָ֡ȡͬʽ㡿ʽȡд򡿡滻ظļĿ¼File

<TTTT  ܽܣܹ105ܣ TTTTT>


ũ˫ѯɶ๦Բѯнڡպũ
߼λ๦ѡ񣨲ңߡѡĳֵСĳֵĳΧֵ֮ıλʱ֧ͨ԰ʽ/λ
ɫǰнɫʾͻʾݲ鿴ضɫɵɫǳͬ๤вƻɫʽճͳ֮ŵ
áùͼƸĿʾ
޸ļʱ䡿:޸ļĴʱ
ɫܡ:ɫѡݺϼ
ѡ񡿣ѡǰδѡ
ǧԪǧڡĬʾµɵ
ʽǰйʽ˿ʽֻܿʽ
б߱ͷExcelûWordб߱ͷߣ߿ֲ˲㡣ߡ˫߿ѡ
ټĸСкڵԪнаټĸ䣬¼ٶ
һطʹԿհ˲ѡöǵǰйָʱҲֻҪ˲
ַ뼰㡿ضԵԪıַ룬Լȡıʽ
ɾյԪ񡿣ɾѡĿյԪ񣬺Զ
תѡѡе
еáѡݺ
еáѡ
ĸСдתѡĵʡĸڴдСдĸд֮ת
СдתдСдתɴд
дתСддתСд
ݼܡԹѡݽмܣת룬ſԲ鿴
ת塿תɷ
ת塿תɼ
ݹʼ㳮ƱԱĹʼҪ100Ԫ50Ԫ......1ԪĳƱ㡣ֽʵĲ߱ر
вСԹвУ߸вУԶ
۷ָֹÿֳɵĹ¹Ƶԭ
۷֡ǰݰֳɶеΪ
ϲָļййݺϲֺϲʽÿеĹϵǰǣӦͬͬݺϲͬһСͬĴ
ıֵѡ˲תıѡı˲תֵ
ѡ򹤾ߡɸѡ򣨷д򹴵ĹߣѡȡѡҿԶ帴ǷԴӡ뵥Ԫӵȵ
䡿WordзܣʹExcelҲͬ๦ܡ̫˷Ѵӡֽʱñ߷ֳɶٴӡ
˲佫ϸɹӡüԼ幤ͷ
ɾָϸɾǰһɵĹͷָϸ
ҳСơÿҳݽСƺۼƣԶҳСƺۼÿҳĩ
ɾҳСơɾСۼƣָϸ
ϲѡһԪֵϵһȥԲ뵽ԭַ֮ǰҲԲ뵽ԭַ֮
ɻԭĺϲСϲʱԱݣָʱȡϲԭ
ϲֵͬһͬڵкϲ
ȡϲԭϲݡһкϲĵԪȡϲһָϲǰ
ϲݲơԽһֱӸƵһԪ
ϲԶС:þкϲԪԶ벻֮л
ͼƬĿ¼ָļͼƬGIFPNGJPGJPEGĿ¼
ͼƬȷƥ䣩˲䵼ѡַͬͼƬԪ񣬿趨ͼƬĴСʽȫͳһ
ͼƬģƥ䣩һ߻һ£ֻȷͼƬʱԺģƥ䡣ѡšԵŵ˵Ƭ
ͼƬעؽͼƬ뵽עУ趨ͼƬʾС
ɾͼƬɾǰͼƬ
ͼƬǰǶͼƬӲгΪJPGͼƬ
ɸԻעExcelֻзע߿ֻıע۴
GIFGIF빤вţԶȡͼƬСҲֹ嶯ĴСλ
FlashFlash빤вţԶȡFlashС,ԶFlashĴСλãFlashǶ빤
ȡѡΨһֵѡݣڵǰУظֵ
ظֵѡظֵɾһγֵݣ
ֹظֵָĳвظָظֵʱԶʾ
ʾظֵظֵòͬɫֱʾͬظֵòͬɫ
ɾհ׵ԪС1ɾհУпհף2ɾհ׵Ԫ
ɸѡΨһֵѡһΪΨһֵɸѡ1ɾظֵУ2ظֵ
ͬ벻ͬȡݵĹͬͲͬҲԶݵĲͬͬбʾ
ļĿ¼ָļеļĿ¼ӣԴ򿪶Ӧļ
Ŀ¼ԵǰйĿ¼ţӣԴ򿪹
½/ƹ½߸ƹ˲佨/1255½ʱȫԶ
ӽܡԹм롢루ֻԼõ룩
ƽ⹤/롿ƽ⹤͹롣ڲ֪ǰһ
ļָļļ޶ļͻ߶ļԭļǰߺƣҲ滻ԭ
ӡǰҳӡǰҳ
˫ӡӡ˫Сר
ӡ׶˱⡿Ϊ׶˱дӡֲExcelֻж˱֮
ϵͳͼ꡿VBAԱõĹߡԲѯExcelڲͼID
ȡIDVBAԱõĹߡԲѯExcelڲID
޸ExcelExcelĳЩ޷ʹʱԵ޹ʶܶ˵ʱ߿˲ָExcelĬ״̬
ƽVBA롿VBAдĳƽ⣬˲
2003ʽ˵Excel 2007Excel 2010רãԲ2003ʽĲ˵ðٱ䣨ã
ơ:ѡʱи
ɫɸѡ:Excel 2003Ҳ԰ɫɸѡݣ20072010ûҪʹá
ɫ:Excel 2003Ҳ԰ɫݣ20072010ûҪʹ
ҳϽĿ¼ʹãκι˲䷵صһ

<TTTTTT    ܽ    TTTTT>
ƣsumifcol
    ɫ͡òеΪѡһΪ򣬵ڶΪɫΪ򣬼һɫڶͬ,򽫶ӦĵĵԪ͡ʡԵԵһ͡
ƣAVER
    ֺȥֵСֵ֮ƽ255Excel2003130
ƣhesum
    Һϲ͡1/2͵ֻ1.5ݺͣΪ1212㣬Ϊ1/21.5㡣
ƣNOWW
	ıĵǰʱ䡣Ҫʱʾڵʱ䣬ʱıı䡣
ƣSFZ
    ֤ϢһΪãڶ롰DQȡص롰XB򷵻Ա롰SR򷵻աԵڶĬʾ
ƣд
    תΪҽдҪһԪá
ƣע
    ȡעеֻ֡һԪá
ƣϲ
    ַϲһΪָڶΪ򡣿""ʾʹ÷ָʼΪ򣬿1254Excel2003129Ҳֱı
ƣȡ
    ıһΪԪ񣻵ڶΪѡΪ0ʡʱʾȡ֣Ϊ1ʱʾų֣Ϊ2ʱʾȡΪ3ȡҼ
ƣΨһֵ
    زظֵԶ1253Excel2003128ȡΨһֵǰΪѡΪѡһΪROWʱкȡֵ,ΪCOLUMNʱкУִСдʼΪ
ƣֵ
    ֵѡж,к֮ʽֵ.,һΪһΪš
ƣɫ
    ɫֵ͡һΪֵڶΪ
ƣɫ
    ɫ֮ͬݸһΪֵڶΪ
ƣ
    ȡһ빤ַعĹӹܡ
ƣ
    롰д෴дַתΪ֡
ƣָȡ
    ָȡһΪԪ񣬵ڶʾȡNʾָ
ƣ
    ĿǰΪ򣬵Ϊš
ƣͬ
    صһжڶûеĿǰ򣬵Ϊš
ƣʽ
    ʽȡԪеĹʽֻҪһԪá
ƣ
    㺯㵥Ԫеıʽ絥ԪΪ456+2458ֻҪһԪá
ƣʽ
    㵥ԪйʽĳȣһԪá
ƣ
    йʽβϣ˲еڶʱȻڵһΪɼ򣬵ڶΪĳɼá
ƣ
    ִ򡣶ݽִַڵһλȻνݡһΪãڶΪΣʹROW(a1)
ƣ滻
    滻NγֵַĺһΪãڶΪ滻ַΪַĲָ滻ڼγֵַΧ1256֮䡣
ƣظ
    жָǷظԪĺֻһΪãΪTrueʱʾظظ
ƣFile
ڴӵļĿ¼·ļ

qTTTTT װɹԭ TTTTTTTr                            
 ޷װע4㣺
 һOFFICEɫ桢棬ǲ֧COMغ  
 رExcel״̬°װɾߣװExcel
VISTAWIN 7ԹԱûװҴӿйصûʻƣUAC
ģװEXCELߣȹصпɾߵĲ˵ 

ڰٱ7.2¸£
_______________________________________________
Aܣ
1.ѡΪͼƬ
2.ɾյԪ
3.תѡ
4.е
5.е
6.ĸСдת
7.
8.޸ļʱ
9.
10.ļĿ¼
11.ͼƬѯ
12.
13.ϲǰ׺
14.File
15.ɫɸѡ
16.ɫ
17.ɫϼ
18.ϲԶ
________________________________________________
Bԭй
1.ͼƬ5
  1ѡĿ¼ʱִеBUG
  2ͼƬȣ
  3󱣳ͼƬԭдСһ£ڹСʱԭСXP
  4ѡļĸʽ
  5VISTAWIN 7BUG,óXPVISTAWIN 7ִ
2.ͼƬ2
1ͼƬ뵥ԪĴСպʶ,7.2еԪСͼƬƥ
2ģƥ书ܡԪǡAôΪABCAAcerȵͼƬͬʱҰ˳ģ
3.ͼƬĿ¼Ŀ¼ԶͼƬҪǰһ潫Ŀ¼͵ͼƬִ
4.ظֵӶԱĵԪ䱳ɫĹܣԼѯûǱһһ
5.ʾظֵֻһЧֻظֵֻһɫҶظֵöͬɫֳ
6.λߣӰʽλ
7.޸Ϊsheetܸǿ󣬶ȡĹӹ
8.ͼƬĿ¼ӽĿ¼ͼƬѯʣѡǾ͵ͼƬ
9.޸Ĳ뺯ķʽ
10.ϲBUGʹԿյԪ
11.ɫɫܣͬʱɫҲԶѡɫûѡСԶж
12.ԭĺϲУϲʱָںϲʽֺϲǰһ£ʱԭȻԻԭ
13.ðٱExcel 2003ʾΪ˵20072010ʾΪ
14.FlashԶжFlashĴСҪָֹ
15.ıܹߵ㷨һ׳
_________________________________________________
 qTTTTTTTTTTTTTTTTTTTTTTr
 U     ʹκʻµĽ           U
 U     ϵ QQ:670218239              U 
 U̳http://andysky.5d6d.com/bbs.php   U 
 tTTTTTTTTTTTTTTTTTTTTTTs  
