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

[¤À¨É] ¾Ç²ßExcel VBAªº¤@¨Ç°ò¥»·§©À

Application.VBE.ActiveVBProject.VBComponents.Remove Application.VBE.ActiveVBProject.VBComponents(.Name) '§R°£

³o¬O¦P¤@¦æªºµ{¦¡½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[img]

Uploaded with ImageShack.us[/img]ÁÙ¦³¤@ÂI°ÝÃD,¥X¤F³o¤@­Ó"¤£¥¿½Tªº¤Þ¥Î"
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-12-15 20:55 ½s¿è

¦^´_ 12# FAlonso
.Name ¿ù»~
¨S¬Ý¨ì¨Ï¥Î¨ì  With ????
                             .Name
                       End With

TOP

¦^´_ 10# FAlonso

§Ú·QÀ³¸Ó¬O   
Application.VBE.ActiveVBProject.VBComponents.Remove Application.VBE.ActiveVBProject.VBComponents(.Name)  '§R°£
¦Ó¤£¬O¤À¦¨¨â¦æ
Application.VBE.ActiveVBProject.VBComponents.Remove
Application.VBE.ActiveVBProject.VBComponents(.Name)  '§R°£

TOP

¦^´_  FAlonso

§Ú·QÀ³¸Ó¬O   
Application.VBE.ActiveVBProject.VBComponents.Remove Application.VB ...
frankjenq µoªí©ó 2010-12-16 10:00



    ¤w¸gÁY¤F¤@¦æ,ÁÙ¬O¦³°ÝÃD
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 15# FAlonso
¸Õ¸Õ¬Ý
  1. Sub c()
  2. With ActiveWorkbook.VBProject.VBComponents.Import("D:\Tony\Excel VBA\a.bas")
  3. Application.Run "a"
  4. Application.VBE.ActiveVBProject.VBComponents.Remove _
  5. Application.VBE.ActiveVBProject.VBComponents(.Name)
  6. End With
  7. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ§@ªÌªº¥Î¤ß¡AÅý§Ú·d²M·¡¬°¦ó¤@­Ó¦Wµü¡A¦³¨º»ò¦hºØ­^¤åªí¥Üªk¡AÁÂÁ¡C
TEBXB

TOP

«Ü·Q¾Ç  ¦ý¤£ª¾¦p¦ó¨Ï¥Îvba  ¤@¤ù¯íµM  §Ú¥u·|¥Î¦b¤u§@ªíªº¤½¦¡©M¨ç¼Æ  ¤]¤£ª¾vba¦b§@¤°»ò  ¤£ª¾¦p¦ó¾Ç

TOP

¦^´_ 18# birdy0815


    birdy:¥i¥H¥ý±q¿ý»s¥¨¶°¶}©l,¥ô¦ó Excel °µªº¤u§@§A³£¥i¥H¿ý°_¨Ó,µM«á¦A¥h¬ã¨s¥¦,¦ý¬O­n¦³­@¤ß­ò,§Ú´¿¸g¿ý¤F¤@­Ó¥¨¶°ªá¤F¤@­Ó¬P´Á¤Ñ¥h¬ã¨s¥¦,¤£·|ªº«ü¥O,¤£À´ªº´N§â´å¼Ð²¾¨ì¤W­±¥h,µM«á«öF1,Helpªº»¡©úÀÉ´N¶]¥X¨Ó¤F,µM«á¥J²Ó¥h¬Ý¥Î¤O¥h¬Ý,³o©Û¤£¦æ´N§â¤£À´ªº½Æ»s°_¨Ó,¥h VBA ªºHelpÀɬdµM«á¥J²Ó¥h¬Ý¥Î¤O¥h¬Ý(¦bVBE¤¤ªº?¸¹ÂI¤@¤U,HelpÀÉ´N¶]¥X¨Ó¤F)´N·|¤F,¦A¤£À´´N¨ì½×¥hµo°Ý,¦³«Ü¦h«e½ú·|À°§U§Ú­Ì,§U¦¨¥\!!/size]

§Ú»¡ªº够¸Ô²Ó¤F,¨ä¥L´N¬Ý§Aªº¤F,§Ú´N¬O³o¼Ë¾Ç·|ªº,¦ý¬OÁÙ¦³«Ü¦h¤£·|ªº,¦ý¬O¨C¤@­Ó¤Hªº±M·~¤£¦P,©Ò¥H§A´N¨ÌµÛ§Aªº±M·~¥h¨«,ºCºCªº§A·|µo²{,§AÁöµM·|ªº¤£¦h¦ý¬O¥i¯à够§A¥Î¤F,§Ú·Q³o´N够¤F,¾ÇªF¦è¤]¤£­n³g¤ß,¤£­n¤°»òªF¦è³£­n¨ì®É­Ô¤°»ò³£­n¤£¨ì.

µù:Excel ¤Wªº Help ÀÉ©M VBA ªº Help ÀɬO¤£¦Pªº,¦pªG§A­n¾Ç VBA ´N­n¶i VBE (Visual Basic Editer) ¥hÂI Help ÀÉ,¤~·|¥X²{§A­nªº Help ÀÉ.


­n¥h¬Ã±¤³o­Ó½×¾Â­ò,.
V98

TOP

ÁÂÁ  §Ú¥ý¥h¸Õ¤@¸Õ¥h¿ý¥¨¶°  ¦A¨Ó¥h¬ã¨s

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD