µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ¦p¦ó¤~¯à§ì¨ìUserForm1.ComboBox1ªº¸ê®Æ?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¦p¦ó¤~¯à§ì¨ìUserForm1.ComboBox1ªº¸ê®Æ?
av8d
µoµu®ø®§
¥[¬°¦n¤Í
av8d
·í«eÂ÷½u
UID
5389
©«¤l
703
¥DÃD
276
ºëµØ
0
¿n¤À
1005
ª÷¿ú
1005
ÂI¦W
1
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2019
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
259 ¤p®É
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-5-29
¤j¾Ç¥Í
©«¤l
703
¥DÃD
276
ºëµØ
0
¿n¤À
1005
ÂI¦W
1
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2019
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-5-29
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-3-18 17:11
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¦p¦ó¤~¯à§ì¨ìUserForm1.ComboBox1ªº¸ê®Æ?
Test.rar
(21.37 KB)
¤U¸ü¦¸¼Æ: 8
2013-3-18 16:43
½Ð¥ý¤U¸ü¸ê®Æ~
¥´¶}EXCEL~µn¤J¨Ï¥ÎªÌ~¨Ï¥ÎªÌ±b¸¹©M±K½X¬Û¦P
µM«á¦bA1¥´¤JAAA«á«ö¤UEnter
D:\©³¤U«h·|¥X²{¤@ÓAAA.xls
©M§Ú쥻µ¹ªº ¨Ï¥ÎªÌ¦WºÙ+¦bA1¥´¤JªºAAA.xls ¤£¦P
¤Ö¤F¨Ï¥ÎªÌ¦WºÙ~UserForm1.ComboBox1
°ÝÃDÂI´N¦b³o¤@¦æ
Save_Name = "D:\" & UserForm1.ComboBox1 & [A1] & ".xls"
UserForm1.ComboBox1 ³Q©¿²¤¤F~¬°¤°»ò·|³o¼Ë©O?
¼Ó¥D¼ö©«
¦p¦óÅý¤U©Ô¿ï³æ¿ï¨ú«á¦Û°Ê¸õ¨ìÀx¦s®æ¬Û¹ïÀ³
°õ¦æ¶¥¬q¿ù»~ '438': ª«¥ó¤£¤ä´©¦¹ÄݩʩΤè
Ãö©óWIN7ªºC:\Windows\Temp©³¤Uªº¸ê®Æ¬O§_¯à
(ÁÂÁ®¦®vÌ¡A7/4§¹¦¨) Ãö©ó¦Ûqªí³æTextBo
¦p¦ó¨ú¦hÓ¤u§@ªí«DªÅ¥ÕªºÈ
§PÂ_¿ï¨ú¬Y¦C©Î¬YÄæÀx¦s®æªºÄæ©Î¦C?(¤w¸Ñµª
¥X²{"¤U¦C¥\¯àµLªkÀx¦s¦bµL¥¨¶°ªº¬¡¶Ã¯"(ÁÂ
»¼¼W±Æ§ÇA1~A10¡A¦p¦óÅýA1«á±¬OA2¦Ó¤£¬OA1
¨Ï¥Î¶W¹L¥Ø«eÀɮ׮榡©Ò¤¹³\ªº±_ª¬¼h¯Å¼Æ¶q
Ãö©ó¿ï¨úÀx¦s®æ«á¡A¸Ó¦C½d³òÅܦâ¡A¥X²{¦ì²¾
¦¬ÂÃ
¤À¨É
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
247
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4100 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-14
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
247
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-14
4
#
µoªí©ó 2013-3-19 16:14
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
av8d
³o¥u¬O§i¶D§A¨Ï¥Î¤½¦@ÅܼƨӨú±o¤w¨ø¸üªí³æªºÈ
¥[¤W$¬O¥Nªí«Å§iÅܼƬ°¦r¦ê«¬ºA
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
av8d
µoµu®ø®§
¥[¬°¦n¤Í
av8d
·í«eÂ÷½u
UID
5389
©«¤l
703
¥DÃD
276
ºëµØ
0
¿n¤À
1005
ª÷¿ú
1005
ÂI¦W
1
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2019
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
259 ¤p®É
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-5-29
¤j¾Ç¥Í
©«¤l
703
¥DÃD
276
ºëµØ
0
¿n¤À
1005
ÂI¦W
1
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2019
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2011-6-30
³Ì«áµn¿ý
2024-5-29
3
#
µoªí©ó 2013-3-19 11:10
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ av8d ©ó 2013-3-19 11:15 ½s¿è
¦^´_
2#
Hsieh
H¤j¤j~
·|Åã¥Ü§ä¤£¨ì¸ê®Æ¦¨û~
Username$©MUsernam¬O¬Û¦Pªº?
©ó¬O§Ú§âUsername$§ï¦¨Username´N¥i¥H¤F^^
½Ð°Ý+$¬O°£¤FÁקK«½ÆIDÁÙ¦³¨ä¥Lªº§t·N¶Ü?(§Ú°O±o¦³¡A¤j¤j¦³»¡¹L)
¦A¦¸·PÁÂH¤j¤jªº¤j¤OÀ°¦£~
TOP
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
247
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4100 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-14
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
247
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-11-14
2
#
µoªí©ó 2013-3-18 23:26
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
av8d
À³¸Ó³]¸m¤@Ó¤½¦@ÅܼÆ
¨Ò¦p:¤@¯ë¼Ò²Õ¤¤¥[¤J
Public Username$
¦bªí³æÃö³¬®É±NComboBox1«ü©wµ¹Username
µM«á¦bWorksheet_Changeµ{§Ç¤¤¥HUsername¥N´ÀUserForm1.ComboBox1
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
ÀR«ä¦Û¦b :
¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·