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

¦p¦ó¥ÎVBA§ó§ï vba modular ªº¦WºÙ

¦^´_ 1# yen956
  1. Function TEST3()
  2. '§ó§ïªº¼Ò²Õ
  3. Set Obj = Application.VBE.ActiveVBProject.VBComponents("Module1")
  4. Row2 = Obj.CodeModule.ProcStart("TEST1", 0)
  5. RowCount = Obj.CodeModule.ProcCounts("TEST1", 0)
  6. Text = Split(Obj.CodeModule.s(Row2, RowCount), vbCrLf)
  7. Randomize
  8. Call Obj.CodeModule.Replace(Row2, "Function TEST2()")
  9.       
  10. End Function
  11. Function TEST1()
  12. '³Q§ó§ïªº¼Ò²Õ
  13. A = B

  14. End Function
½Æ»s¥N½X
PKKO

TOP

¥»©«³Ì«á¥Ñ PKKO ©ó 2017-2-6 12:30 ½s¿è

¬¡­¶Ã¯1.rar (10.64 KB) ¦^´_ 4# yen956

¤£¥Î¤Þ¥Î¶µ¥Ø
¤U¸üÀɮת½±µ¶}±ÒVBEµe­±°õ¦æ²Ä¤@­Ó¥¨¶°§Y¥i§ó§ï²Ä¤G­Ó¥¨¶°ªº¼Ò²Õ¦WºÙ

¼Ò²Õ¤£¥i¤WÂê

­Y¦³¤WÂê¼Ò²Õ,·|»Ý­n§ó¦hCODE
PKKO

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD