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

VBA¤º¦Û°Ê®Ö¨ú¤wµù¥Uªº COM AddIn ¤Þ¥Î¶µ¥Ø

VBA¤º¦Û°Ê®Ö¨ú¤wµù¥Uªº COM AddIn ¤Þ¥Î¶µ¥Ø

½Ð°ª¤â¤j¤j«üÂI¡G

COM AddIn    .dll ¦bVBProject¤º¤w¥Î Regsvr32.exe µù¥U¡A
¦ý¬O¦p¦ó¦Û°Ê®Ö¨ú¤Î®Ö¾P¸Ó¤Þ¥Î¶µ¥Ø(¦b®Ö¨ú¤è®æ¤º¥´¤Ä¤Î¥h°£¥´¤Ä) ?
¥H§K¥Î¤â°Ê¤Þ¥Î

¸U¤À·PÁÂ

¦^´_ 1# Scott090

³o­ÓÃD¥Ø®£©È¨S¦³µª®×¤F!?

TOP

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 3# GBKEE


    «D±`·P®¦¤j¤jªº«ü¾É
§¹¦¨ªºÀ³¥Î¬O¡G
1. ¦Û°Ê®Ö¨ú¤Þ¥Î¶µ¥Ø (­«ÂI¬O¨Ï¥Î AddFromFile ªº¤èªk)
    ThisWorkbook.VBProject.References.AddFromFile ThisWorkbook.Path & "\mydll.dll"

2. ¦Û°Ê®Ö®ø¤Þ¥Î¶µ¥Ø
    VBProject.References.Remove ThisWorkbook.VBProject.References.Item("mydll")

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD