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

[µo°Ý] ¦p¦ó¸Ñ¨MExcel VBA§ä¤£¨ì³]©w¤Þ¥Îªº¶µ¥Ø¤¤ªº¤¸¥ó

[µo°Ý] ¦p¦ó¸Ñ¨MExcel VBA§ä¤£¨ì³]©w¤Þ¥Îªº¶µ¥Ø¤¤ªº¤¸¥ó

¦p¦ó¸Ñ¨MExcel VBA§ä¤£¨ì³]©w¤Þ¥Îªº¶µ¥Ø¤¤ªº¤¸¥ó

¤@¯ë
³]©w¤Þ¥Îªº¶µ¥Ø¤¤ªº¤¸¥ó
¤j³£ ¥H
*.olb  *.tlb  *.dll  ªºÀɮפ¸¥ó
°ÝÃD¬O »Ý­n¥Î¨ì *.exe ªºÀɮפ¸¥ó ®É

µ{¦¡ ¤@¥¹ ¤¤Â_ Â÷¶}«á(­«±Ò)
Excelªº
³]©w¤Þ¥Îªº¶µ¥Ø¤¤ªº¤¸¥ó
´NµLªk°õ¦æ (¥X²{ ¿ù»~) ¤¸¥ó¨S¦³ ¥X²{¿òº|

¥u¯à (­«±Ò) Excel
­«·s °»´ú ¥Î *.exe ªºÀɮפ¸¥ó

¦p¦ó¥i¥H (¤£­«±Ò) Excel ¤U
­«·s ©I¥s ¥Î *.exe ªºÀɮפ¸¥ó



¥i¥H ¦p¦ó¸Ñ¨M¦¹¤@°ÝÃD ·PÁÂ~~
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-7-1 21:56 ½s¿è

¦^´_ 1# 7777

https://blog.gtwang.org/programming/excel-vba-debug-error-handling/2/
§Ú¦b²q §A­nªº·|¤£·|¬O³o­Ó


on error goto ErrorHandler
...
...
xxx  <°»´ú¨ì¿ù»~ ´N·|ª½¸õ¶}
...
...
ErrorHandler:   ·|¦Û°Ê¸õ¨ì³o­Ó³¡¤À
set xx = nothing
exit sub

³o¼Ë´N¯à°{¹L¿ù»~ ¦ý¤]¤£¤@©w¯à¦¨¥\¡@¥i¥H¥ý¸Õ¸Õ¬Ý

TOP

¦^´_ 2# singo1232001


    ¤Þ¥Î
https://www.mrexcel.com/board/threads/use-vba-to-install-excel-reference.590567/


With Workbook.reference
.AddFromFile "¥Î *.exe ªºÀɮפ¸¥ó ¸ô®|"
End With


­«·s©¿¥s«á...´N¤£¥Î (­«±Ò)

¤è¦¡¸Ñ¨M
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD