µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Macro List
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
Macro List
quickfixer
µoµu®ø®§
¥[¬°¦n¤Í
quickfixer
·í«eÂ÷½u
UID
28599
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ª÷¿ú
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
¦b½u®É¶¡
673 ¤p®É
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
¤¤¾Ç¥Í
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
1
#
¸õÂà¨ì
»
µoªí©ó 2020-4-17 06:24
|
Åã¥Ü¥þ³¡©«¤l
¦^´_
1#
PJChen
ÀH«Kgoogle´N¦³¤@°ï²{¦¨ªº¸Ñµª¤F,³oÓ¦C¥X¬¡¶Á¡¤¤©Ò¦³ªºmacro name
http://www.vbaexpress.com/kb/getarticle.php?kb_id=398
excel 2016¥i¥¿±`°õ¦æ
TOP
quickfixer
µoµu®ø®§
¥[¬°¦n¤Í
quickfixer
·í«eÂ÷½u
UID
28599
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ª÷¿ú
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
¦b½u®É¶¡
673 ¤p®É
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
¤¤¾Ç¥Í
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
2
#
µoªí©ó 2020-4-17 06:47
|
Åã¥Ü¥þ³¡©«¤l
¦^´_
1#
PJChen
³oÓ¦C¥X¨ä¥¦Àɮתº macro name §t module name
https://superuser.com/questions/1365898/macro-vba-code-to-list-and-print-names-and-code-of-all-macros-in-a-workbook
nuserform¡Bcommandbutton¡Blistbox
¨ä¤¤ objXLABC.Close n§ï¦¨objXLABC.Close False,¤£µMµ{¦¡·|¥d¦í
excel 2016¥i¥¿±`°õ¦æ
TOP
quickfixer
µoµu®ø®§
¥[¬°¦n¤Í
quickfixer
·í«eÂ÷½u
UID
28599
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ª÷¿ú
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
¦b½u®É¶¡
673 ¤p®É
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
¤¤¾Ç¥Í
©«¤l
151
¥DÃD
1
ºëµØ
0
¿n¤À
197
ÂI¦W
15
§@·~¨t²Î
windwos 7
³nÅ骩¥»
64bit
¾\ŪÅv
20
µù¥U®É¶¡
2017-5-29
³Ì«áµn¿ý
2024-4-29
3
#
µoªí©ó 2020-4-18 00:06
|
Åã¥Ü¥þ³¡©«¤l
¥»©«³Ì«á¥Ñ quickfixer ©ó 2020-4-18 00:14 ½s¿è
¦^´_
5#
PJChen
ºô§}¤ºªºmicrosoft³sµ²¤£¬O¦³»¡©ú?»Ý¥ý³]©w¤Þ¥Î¶µ¥Ø
Microsoft Visual Basic for Applications Extensibility 5.3
¥´¤Ä
¤U¸ü
(57.61 KB)
2020-4-18 00:05
²Ä¤@Ócode ¸Ì±¤]¦³»¡©ún¤Þ¥Î
¤U¸ü
(67.98 KB)
2020-4-18 00:03
¤£µM§â²Ä¤@Ócode¸Ì±ªº³o2¦æ
On Error Resume Next
ThisWorkbook.VBProject.References.AddFromGuid _
"{0002E157-0000-0000-C000-000000000046}", 5, 3
¥[¨ì²Ä¤GÓcode¸Ì±³Ì«e±,¥i¥H§ï¦¨¥Îµ{¦¡½X¦Û°Ê¤Þ¥Î
TOP
ÀR«ä¦Û¦b :
«Î¼e¤£¦p¤ß¼e¡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¯»µ·