ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¤~¯à§ì¨ìUserForm1.ComboBox1ªº¸ê®Æ?

[µo°Ý] ¦p¦ó¤~¯à§ì¨ìUserForm1.ComboBox1ªº¸ê®Æ?

Test.rar (21.37 KB)

½Ð¥ý¤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?

¦^´_ 1# av8d


    À³¸Ó³]¸m¤@­Ó¤½¦@ÅܼÆ
¨Ò¦p:¤@¯ë¼Ò²Õ¤¤¥[¤J
Public Username$
¦bªí³æÃö³¬®É±NComboBox1«ü©wµ¹Username
µM«á¦bWorksheet_Changeµ{§Ç¤¤¥HUsername¥N´ÀUserForm1.ComboBox1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ 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

¦^´_ 3# av8d


    ³o¥u¬O§i¶D§A¨Ï¥Î¤½¦@ÅܼƨӨú±o¤w¨ø¸üªí³æªº­È
¥[¤W$¬O¥Nªí«Å§iÅܼƬ°¦r¦ê«¬ºA
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD