¬°¤°»òµ{¦¡¶]¨ì¤@¥b³£·|°±¦í¤£Ä~Äò¤F?
- ©«¤l
- 287
- ¥DÃD
- 65
- ºëµØ
- 0
- ¿n¤À
- 357
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFIC 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-6-4
- ³Ì«áµn¿ý
- 2015-8-19
|
¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-31 08:46 ½s¿è
¦^´_ 3# sasho
¸Õ¸Õ¦bcode.xls ªºA1¤J =SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")
´N·|¦³code.xls ªºLINK
eg. C:\code.xls
Workbooks.Open Filename:="C:\code.xls"
MyCodeName= ActiveWorkbook.Name
Workbooks(MyCodeName).Activate |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 287
- ¥DÃD
- 65
- ºëµØ
- 0
- ¿n¤À
- 357
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFIC 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-6-4
- ³Ì«áµn¿ý
- 2015-8-19
|
¦^´_ 9# sasho
¤èªk 1. ¥u¦n¤£¥Îmsn.
¤èªk 2. ¶R¥x±j«lªº¹q¸£. |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|