¦b¤u§@ªí°õ¦æ¥t¤@®æ¤u§@ªíªº¥¨¶°
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¦b¤u§@ªí°õ¦æ¥t¤@®æ¤u§@ªíªº¥¨¶°
½Ð±Ð¦U¦ì¤j¤j:
³o¬O°õ¦æ¨ä¥L¬¡¶Ã¯ªº¥¨¶°µ{¦¡
Sub Sample()
Application.Run "Àɮצì¸m!Module1.Macro1"
End Sub
¦pªG§Ú·Q§ï¦¨¦b¦P¤@Ó¤u§@ï¤W²Ä¤@Ó¤u§@ªí¤W°õ¦æªº¤GÓ¤u§@ªí¤Wªº¥¨¶°
½Ð°Ýn¦p¦ó¼g³oÓµ{¦¡
ÁÂÁÂ |
|
michael
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 13
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-10-25
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2016-4-25 23:42 ½s¿è
½Ð±Ð¦U¦ì¤j¤j:
³o¬O°õ¦æ¨ä¥L¬¡¶Ã¯ªº¥¨¶°µ{¦¡
Sub Sample()
Application.Run "Àɮצì¸m!Module1.Mac ...
chairles59 µoªí©ó 2016-4-25 00:54
Call Sheets("Sheet2").cc
©Î
Sheets("Sheet2").cc |
|
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¦^´_ 2# luhpro
ÁÂÁ¤j¤j
¦]¬°¤H¦b®È¹C¡A
¤â¤¤¨S¦³¹q¸£¥i¥H´ú¸Õ
©ú¤Ñ¦^¥h¦A´ú¸Õ |
|
michael
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¦^´_ 2# luhpro
¤j¤j:
´ú¸Õ¦n¹³¤£¦æ
¥L¥X²{
°õ¦æ¶¥¬q¿ù»~9
°}¦C¯Á¤Þ¶W¥X½d³ò
Call Sheets("Sheet2").cc
.cc¬O¬Æ»ò·N«ä
½Ð¤j¤jÀ°§Ú±Ð¾É¤@¤U |
|
michael
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 13
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-10-25
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2016-4-29 00:08 ½s¿è
¦^´_ luhpro
¤j¤j:
´ú¸Õ¦n¹³¤£¦æ
¥L¥X²{
°õ¦æ¶¥¬q¿ù»~9
°}¦C¯Á¤Þ¶W¥X½d³ò
Call Sheets("Sheet2").cc
chairles59 µoªí©ó 2016-4-28 22:08
§A#1 ªº±Ôz¬O :
¦pªG§Ú·Q§ï¦¨¦b¦P¤@Ó¤u§@ï¤W²Ä¤@Ó¤u§@ªí¤W°õ¦æªº¤GÓ¤u§@ªí¤Wªº¥¨¶°
¬Ý¤£¥X¨Ó ¥¨¶°©Ò¦b¤u§@ªíªº¦WºÙ,
¤Î·Q°õ¦æªº¥¨¶°¦WºÙ,
©Ò¥H§Ú¥u¯à¦Û¤vq,
§An§ï¦¨§AÀɮפ¤ªº¦WºÙ,
¦Ó¤£¬Oª½±µ·Ó·h.
·|¥X²{ °}¦C¯Á¤Þ¶W¥X½d³ò ªº¿ù»~¬O¥¿±`ªº,
¦]¬°§AªºÀɮ׸̨S¦³¦WºÙ¬° Sheet2 ªº¤u§@ªí.
Call Sheets("Sheet2").cc
¤W¦¡¤¤:
1. Sheet2 ¬O¤u§@ªí¦WºÙ, ½Ð±a¤J§A·Qn°õ¦æªº¥¨¶°©Ò¦bªº¤u§@ªí¦WºÙ.
2. cc ¬O¥¨¶°¦WºÙ, ½Ð±a¤J§A·Qn°õ¦æªº¥¨¶°ªº¦WºÙ. |
|
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¥»©«³Ì«á¥Ñ chairles59 ©ó 2016-4-29 21:21 ½s¿è
[attach]24108[/attach][attach]24108[/attach]¦^´_ 5# luhpro
luhpro ¤j¤j:
¦n¹³¤]¤£¦æ
§Ú§âÀ£ÁYÀɮתþ¤W
½Ð¤j¤jÀ°§Ú¬Ý¤@¤U«ö¶s7ªº¥¨¶°¨º¸Ì¦³°ÝÃD
ÁÂÁÂ
ps:·Ç¤j¤j¤£¦n·N«ä
±zªºµ{¦¡§Ú¥[¤F¦n¦hÓ«ö¶s |
-
-
ªÑ²¼.rar
(49.56 KB)
|
michael
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¦^´_ 5# luhpro
luhpro ¤j¤j:
¤£¦n·N«ä§Ú¦b¶}µo¤Hû°õ¦æ°»¿ù,«öF8®É¥L§i¶D§Ú
°õ¦æ¶¥¬q¿ù»~438
ª«¥ó¤£¤ä´©¦¹ÄݩʩΤèªk
¦ý¬O§Ú¦bSheet1(§Y®É¸ê°T)·s¼WªÑ²¼«ö¶s«o¯à°õ¦æ |
|
michael
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 13
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-10-25
|
¦^´_ 7# chairles59
§Aªº Sheets("®æ¦¡") ¸Ì¨Ã¨S¦³ ·s¼WªÑ²¼¦WºÙ ³oÓ Sub,
©I¥s·íµM·|¥¢±ÑÅo...
§A¥un§â Sheets("®æ¦¡"). ®³±¼,
§ï¬°ª½±µ©I¥s "·s¼WªÑ²¼¦WºÙ" §Y¥i:- Sub ½Æ»s®æ¦¡¤u§@ªí()
- ·s¼WªÑ²¼¦WºÙ
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win 8.0
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2020-4-13
|
¦^´_ 8# luhpro
ÁÂÁ¤j¤jªº±Ð¾É
:) |
|
michael
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 9# chairles59
³o¥i¤À¦¨¨â³¡¤À¨Ó»¡©ú¡AµL½×¬O¦óºØ¤è¦¡µª®×¬O¤@Pªº¡A
®t§O¥u¦b©óªí¹Fªº¤è¦¡¦]¤H¦Ó²§¡G
A. ±N¡y·s¼WªÑ²¼¦WºÙ¡zµ{¦¡ (·s¼WªÑ²¼¦WºÙ())
©ñ¸m©ó ¡u¤u§@ªí1 (®æ¦¡)¡v ¤º
©I¥s¤è¦¡¤@¡G- Sub ½Æ»s®æ¦¡¤u§@ªí()
- Sheets("®æ¦¡").·s¼WªÑ²¼¦WºÙ
- End Sub
½Æ»s¥N½X ©I¥s¤è¦¡¤G¡G- Sub ½Æ»s®æ¦¡¤u§@ªí()
- Call Sheets("®æ¦¡").·s¼WªÑ²¼¦WºÙ
- End Sub
½Æ»s¥N½X ©I¥s¤è¦¡¤T¡G- Sub ½Æ»s®æ¦¡¤u§@ªí()
- ¤u§@ªí1.·s¼WªÑ²¼¦WºÙ
- End Sub
½Æ»s¥N½X ©I¥s¤è¦¡¥|¡G- Sub ½Æ»s®æ¦¡¤u§@ªí()
- Call ¤u§@ªí1.·s¼WªÑ²¼¦WºÙ
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|