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

[µo°Ý] °õ¦æModule1µ{¦¡½Xªº»yªk

[µo°Ý] °õ¦æModule1µ{¦¡½Xªº»yªk

¥»©«³Ì«á¥Ñ papaya ©ó 2019-3-20 09:17 ½s¿è

VBA.rar (58.67 KB)

½Ð°Ý: °õ¦æModule1µ{¦¡½Xªº»yªk­n¦p¦ó¼¶¼g?ÁÂÁÂ!

¥»©«³Ì«á¥Ñ papaya ©ó 2019-3-20 11:50 ½s¿è

¦^´_ 1# papaya
ªþÀɦ³»~~§ó·s~

½Æ»s¤u§@ªí_VBA.rar (62.95 KB)

PS:ª¾¹D±NModule1µ{¦¡½Xªº¦C2~¦C6°Å¤U¶K¤W¡A¦A±NModule1²¾°£§Y¥i¡F¦ý¦]¬°·Q¬ã²ß»yªk¡A©Ò¥H¦³¦¹¤@°Ý¡A·Ð½Ð¦U¦ì¤j¤j«ü±Ð!ÁÂÁÂ¥ý!

TOP

¦^´_ 2# papaya
¥H¿ý»s¥¨¶°±o:   
Application.Run "½Æ»s¤u§@ªí_VBA.xls!Macro1"
¦ýÅã¥Ü


§ï¬°
Application.Run "½Æ»s¤u§@ªí_VBA.xls!Module1"
ÁÙ¬OÅã¥Ü

TOP

¦^´_ 3# papaya
  1. Private Sub CommandButton1_Click()
  2. '½Ð°Ý:°õ¦æModule1µ{¦¡½Xªº»yªk¡CÁÂÁÂ!
  3.     ½Æ»s¤u§@ªí
  4. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE

«¢~«¢~µª®×¥X¥G·N®Æ~
OK¤F~ÁÂÁ±z!

TOP

¦^´_ 4# GBKEE
GBKEE¶Wª©¤j:
¤U¦Cªº´£°Ý¡A¥i§_½Ð±z¦bÀ°¦£©M½ç±Ð~
http://forum.twbts.com/thread-21616-1-1.html
ÁÂÁ±z!

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD