[µo°Ý] office 2010 ¤¤ right©Î left ©Î mid ¨ç¼ÆµLªkÃѧO

yangjie

½Ð±Ð½Ñ¦ì¤j¤j
©óoffice 2003 ¤¤ right(str1,5) ©Î left ©Î mid(str1,5,3)  «Ü¦n¥Î
¦ý¦b office 2010 ¤¤ right(str1,5) ©Î left ©Î mid(str1,5,3) µLªkÃѧO
À³¦p¦ó­×¥¿?

yangjie

¦^´_ 5# Hsieh
º}«G   ÁÂÁÂ

Hsieh

¦^´_ 3# yangjie
¤u¨ã/¤Þ¥Î¶µ¥Ø
±N¿òº|ªº¶µ¥Ø¨ú®ø¤Ä¿ï

c_c_lai

¦^´_ 3# yangjie
¥H¤Uµ{¦¡½X¬O¥¿½Tªº (µL½×¬O 32 ¦ì¤¸¡B©Î¬O 64 ¦ì¤¸)
Left()¡BMid()¡BRight() ¦b¥ô¦óµ{¦¡»y¨¥¤¤¡A¨Ï¥Î¤è¦¡³£¬O¤@­Pªº¡A
¥B¬O³Ì°ò¥»ªº¤º¦b¨ç¦¡¡C

1. Sub Ex()
   
2.     tt45    '  °õ¦æ tt45 ¡B©ÎªÌ¬O Call tt45 §¡¥i
   
3.     '  Call tt45
   
4. End Sub
   
5. 
   
6. Sub tt45()
   
7.     Dim str1 As String
   
8.     str1 = "asdfg123ghj"
   
9.     MsgBox Left(str1, 5)
   
10. End Sub

½Æ»s¥N½X

yangjie

¦^´_ 2# c_c_lai
run tt45
Sub tt45()
    Dim str1 As String
    str1 = "asdfg123ghj"
    MsgBox Left(str1, 5)
End Sub
§Y¥X²{µøµ¡  
½s¿è¿ù»~
§ä¤£¨ì±M®×©Îµ{¦¡®w
(§Ú¥Îªº¬Ooffice2010 X64)

c_c_lai

¦^´_ 1# yangjie
§A«üªº¬O¡H

¤U¸ü (77 KB)

2014-7-2 14:57