½Ð°Ý¦p¦ó¦ÛÀɮ׸ô®|ªº¦r¦ê¤¤¡A©î¥X¸ô®|©MÀɦW?
- ©«¤l
- 14
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- excel 2000
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-5-17
- ³Ì«áµn¿ý
- 2023-3-24
|
½Ð°Ý¦p¦ó¦ÛÀɮ׸ô®|ªº¦r¦ê¤¤¡A©î¥X¸ô®|©MÀɦW?
½Ð°Ý¦U¦ì¥ý¶i~
Windows("filename.xls").Activate¬O¤£¬O¤£¯à¤Þ¥Î¸ô®|?¨Ò¦pWindows("F:\§Úªº¤å¥ó\9908\filename.xls").Activate
¦pªG³o¼Ëªº¸Ü¡A§Ú·Q§â¸ô®|©MÀɦW¤À§O©î¥X(¸ô®|©MÀɦW³£¤£¬O©T©wªø«×)¡A¦A ChDir¦n¤F~
strDir = "F:\§Úªº¤å¥ó\9908\"
strFile = "filename.xls"
½Ð°Ý«ç»ò³B²zªü??
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- excel 2000
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-5-17
- ³Ì«áµn¿ý
- 2023-3-24
|
¤Ó·PÁ¦U¦ì¥ý¶iªº¼ö¤ß¤F¡A
¤p§Ì¯u¬O¨ü±Ð¤F~ÁÂÁ¨C¤@¦ì~ |
|
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 16
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-14
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2010-9-3 00:37 ½s¿è
¥un§ä¨ì³Ì«á¤@Ó "\" ªº¦ì¸m,
¦A¨Ì¦¹±N§¹¾ãªºÀɦW¦r¦ê¤À§O©î¶}¨ú¥Î§Y¥i.
Dim sStr$, i%, strDir$, strFile$
sStr = "F:\§Úªº¤å¥ó\9908\filename.xls"
i = InStrRev(sStr, "\", Len(sStr), 1)
strDir = Left(sStr, i)
strFile = Mid(sStr, i + 1, Len(sStr) - i) |
|
|
|
|
|
|
- ©«¤l
- 133
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 147
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-11-11
|
±q¦r¦ê¨úÀɦWªº¤è¦¡,¥i°Ñ¦Ò.
http://gb.twbts.com/index.php?topic=4068.0
¦pªG¥Î°j°é³B²z..
a = "F:\§Úªº¤å¥ó\9908\filename.xls"
For i = Len(a) To 1 Step -1
If Mid(a, i, 1) = "\" Then
file_name = Right(a, Len(a) - i)
file_path = Left(a, i - 1)
Exit For
End If
Next i |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- excel 2000
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-5-17
- ³Ì«áµn¿ý
- 2023-3-24
|
±z»~·|§Ú·N«ä¤F~¬O¥t¤@ÓÀÉ
¥u¬O§Ú§â"§¹¾ã¸ô®|\ÀɦW"·í§@°Ñ¼Æ¡AWindows().Activate´N¤£WORK¤F~ |
|
|
|
|
|
|
- ©«¤l
- 133
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 147
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-11-11
|
¦^´_ 1# examsuper
Windows("F:\§Úªº¤å¥ó\9908\filename.xls").Activate ³o»yªk¦ü¥G¨S¥²n..?
¦]¬°¦P¤@®É¶¡,¤£·|¶}¨âÓ¦P¼ËÀɦWªº excel ÀÉ®×.. |
|
|
|
|
|
|