- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 93
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-4-18
               
|
¦^´_ 3# t8899
º¥ý§An·d²M·¡©Ò¿×¥~³¡°Ñ·Ó³sµ²
·í¤½¦¡ªº°Ñ·Ó¡A·|«ü¦V¥»¨¤u§@ªí¥H¥~ªºÀx¦s®æ´N¬O¥~³¡°Ñ·Ó³sµ²
³o¬O¥H¤½¦¡ª½±µ¼¶¼g°Ñ·Ó¦ì§}
¨Ò¦p:
='D:\EXCEL\[1020314.xls]Sheet1'!A1
³o¼Ë¬O¤@Ó§¹¾ã¸ô®|°Ñ·Ó
Y±N¦¹°Ñ·Ó¦r¦ê¨ä¤¤¬Y³¡¥÷¨ú¥N¡A¦p¨ä¤¤ÀɦW³¡¤À1020314¥HÀx¦s®æ¤º®e¨ú¥N
='D:\EXCEL\[&AA46&.xls]Sheet1'!A1
ÁöµM¤£·|²£¥Í¿ù»~°T®§¡A¦ý¬O·í§A¿é¤J§¹¤½¦¡®É¡AEXCEL·|n¨D«·s«ü©w³sµ²ÀɮסA¨Ã¥B¤£¯à»PAA46¤º®e¶i¦æ¦P¨BÅܤÆ
n¯à°÷¥¿½T±N¸Ó¦r¦êÂà´«¦¨°Ñ·Ó¡A´N¥²¶·¨Ï¥ÎINDIRECT¨ç¼Æ
=INDIRECT("'D:\EXCEL\["&AA46&".xls]Sheet1'!A1")
¦ý¬O¡AINDIRECT¨ç¼Æªº¨Ï¥Î¥²¶·¬O¥~³¡³sµ²ÀÉ®×¥²¶·¬°¶}±Òª¬ºA
©Ò¥H§An¦b°Ñ·Ó¸ô®|¤¤¨Ï¥ÎÅܼƬO¤£¥i¦æªº
¥i¨Ï¥Î¦r¦ê¹Bºâ¼g¤J¤½¦¡ªº¦r¦ê
µM«á¥Î¿ï¾Ü©Ê¶K¤WÈ¡AÅܦ¨¤½¦¡¦r¦ê
¦A§Q¥Î¸ê®ÆåªR±N¤½¦¡¦r¦êÂà´«¦¨¤½¦¡
|
|