Microsoft Office XP
CommandBarButton °³Ã¼¿¡ µÎ °³ÀÇ »õ ¼Ó¼ºÀ» ¼Ò°³ÇÕ´Ï´Ù:
¸¶½ºÅ© ¹×
±×¸² ¼Ó¼ºÀ». ÀÌ·¯ÇÑ ¼Ó¼ºÀº ±×¸²ÀÌ »ý¼ºµÈ »ç¿ëÀÚ ÁöÁ¤ ¸í·É ¸ðÀ½ ÄÁÆ®·ÑÀ» ¹èÄ¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Âü°í ÀÌ·¯ÇÑ ¼Ó¼ºÀ» Microsoft Office 2003¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
Mask ¹×
±×¸² ¼Ó¼ºÀº Stdole ¶óÀ̺귯¸®ÀÇ ¸â¹ö ÀÎ
IPictureDisp, Çü½ÄÀ¸·Î Á¤Àǵ˴ϴÙ.
IPictureDisp ÇÁ·Î¼¼½º °æ°è¿¡ °ÉÃÄ ¹è¿µÈ ¼ö ¸Þ¼µå¸¦ »ç¿ëÇÕ´Ï´Ù. µû¶ó¼,
¸¶½ºÅ© ¹×
±×¸² ¼Ó¼ºÀ» ´ëÇØ¼¸¸ in-process È£ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù (VBA ¸ÅÅ©·Î¸¦, ÀÚµ¿È Ãß°¡ ±â´É ¹× ActiveX DLLÀ» ÇÁ·Î¼¼½º ½ÇÇà). ÀÌ µ¿ÀÛ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº "ÂüÁ¶" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ.
¾Æ·¡ ¿¹Á¦¿¡¼´Â ÀÚµ¿È Ãß°¡ ¸¶½ºÅ©µÈ ±×¸²À¸·Î CommandBar ´ÜÃ߸¦ Ãß°¡ÇÏ´Â ±â´É¿¡¼ ¸¸µå´Â ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù.
±×¸² ¹× »ç¿ëÇÏ¿© ¸¶½ºÅ© À̹ÌÁö¸¦ ¸¸µå´Â ´Ü°è
- Microsoft ±×¸²ÆÇ ½ÃÀÛÇϽʽÿÀ. À̹ÌÁö ¸Þ´º¿¡¼ ¼Ó¼º À» Ŭ¸¯ÇϽʽÿÀ. 32 x 32 À̹ÌÁö Å©±â¸¦ º¯°æÇÑ ´ÙÀ½ È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
- ³ë¶õ»ö Ç¥¸é ±×¸®±â ȸ鿡 ±×¸³´Ï´Ù. ÆÄ¶õ»ö ¿øÀ¸·Î ÁÖº¯ ¿µ¿ªÀ» ä¿ó´Ï´Ù.
- À̹ÌÁö¸¦ Circle.bmp ÆÄÀÏ·Î ÀúÀåÇϽʽÿÀ.
- ¸¶½ºÅ©¸¦ ¸¸µé·Á¸é ÇÔ²² °ËÁ¤ ¿ø ä¿ì°í ¿ø ¹Û¿¡¼ ¿µ¿ªÀ» Èò»öÀ¸·Î ä¿ì±â. ¸¶½ºÅ©°¡ ±×¸² CommandBar ÄÁÆ®·Ñ¿¡ Ãß°¡µÉ ¶§ Èò»ö ¿µ¿ªÀº Åõ¸íÇÑ µ¿¾È¿¡´Â ¸¶½ºÅ©ÀÇ °ËÁ¤ ¿µ¿ª Ç¥½ÃµË´Ï´Ù.
- À̹ÌÁö¸¦ Mask.bmp ÆÄÀÏ·Î ÀúÀåÇϽʽÿÀ.
COM AddIn ¸¸µå´Â ´Ü°è
- Visual Basic ½ÃÀÛÇÏ°í »õ AddIn ¸¸µé ÇÁ·ÎÁ§Æ®.
- ÇÁ·ÎÁ§Æ® ¸Þ´º¿¡¼ ÂüÁ¶ ¸¦ ´©¸¨´Ï´Ù. "Office Çü½Ä ¶óÀ̺귯¸®¸¦ °æ¿ì XP ¼±ÅÃÇÑ ¹öÀüº¸´Ù ÀÌÀü, ÀÏ¹Ý ÇØ´ç Çü½Ä ¶óÀ̺귯¸® ¹× Microsoft Office XP¿¡ ´ëÇÑ Çü½Ä ¶óÀ̺귯¸®¸¦ ¼±ÅÃÇÕ´Ï´Ù. È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
- ÇÁ·ÎÁ§Æ® Ž»ö±â¿¡¼ frmAddin ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÑ ´ÙÀ½ frmAddin Á¦°Å ¸¦ Ŭ¸¯ÇϽʽÿÀ.
- ÇÁ·ÎÁ§Æ® Ž»ö±â¿¡¼ ¿¬°á µðÀÚÀ̳ʸ¦ µÎ ¹ø Ŭ¸¯ÇϽʽÿÀ. ÀÀ¿ë ÇÁ·Î±×·¥¿¡ ´ëÇÑ Microsoft Excel À» ¼±ÅÃÇÏ°í ½ÃÀÛÃÊ±â ·Îµå µ¿ÀÛ ¼±ÅÃÇϽʽÿÀ.
- º¸±â ¸Þ´º¿¡¼ ÄÚµå ¸¦ Ŭ¸¯ÇÏ¿© ¹× Ãß°¡ - ÇÔ²² ´ÙÀ½ Äڵ带 ¹Ù²ß´Ï´Ù:
Option Explicit
Dim oExcel As Object
Dim WithEvents oButton As Office.CommandBarButton
Private Sub AddinInstance_OnConnection(ByVal Application As Object, _
ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, _
ByVal AddInInst As Object, custom() As Variant)
Dim oPic As stdole.IPictureDisp
Dim oMask As stdole.IPictureDisp
' Load the picture and mask.
Set oPic = LoadPicture(App.Path & "\circle.bmp")
Set oMask = LoadPicture(App.Path & "\mask.bmp")
' Save an instance of our application.
Set oExcel = Application
' Create a new button on the standard CommandBar.
Set oButton = oExcel.CommandBars("Standard").Controls.Add(msoControlButton)
With oButton
' Set a tag for the button.
.Tag = "My Button"
' Set the event to fire when the button is pressed.
.OnAction = "!<" & AddInInst.ProgId & ">"
' Set the picture property -- if you are using the Mask property, this
' property must be set before you set the Mask property.
.Picture = oPic
' Set the Mask property.
.Mask = oMask
' Show the button.
.Visible = True
End With
End Sub
Private Sub AddinInstance_OnDisconnection(ByVal RemoveMode As _
AddInDesignerObjects.ext_DisconnectMode, custom() As Variant)
' Delete the button.
oButton.Delete
' Release references.
Set oButton = Nothing
Set oExcel = Nothing
End Sub
Private Sub oButton_Click(ByVal Ctrl As Office.CommandBarButton, _
CancelDefault As Boolean)
' Our button was pressed.
MsgBox "The button was pressed!"
End Sub
- ÇÁ·ÎÁ§Æ®¸¦ ÀúÀåÇϰí Ãß°¡ ±â´ÉÀÇ ºñÆ®¸ÊÀÌ ÀúÀåµÈ Æú´õ¿¡ ºôµåÇϽʽÿÀ.
- ExcelÀ» ½ÃÀÛÇϽʽÿÀ. ³ë¶õ»ö ¿ø ÀÖ´Â »õ ÄÁÆ®·ÑÀÌ Ç¥ÁØ CommandBar µû¶ó ³ªÅ¸³³´Ï´Ù. ¿µ¿ª ÁÖÀ§¿¡ ³ë¶õ»ö ¿ø Åõ¸íÇÕ´Ï´Ù À¯ÀÇÇϽʽÿÀ.
Ãß°¡ Á¤º¸¾Õ¿¡¼ ¼³¸íÇÑ °Íó·³
IPictureDisp ÀÎÅÍÆäÀ̽º ÇÁ·Î¼¼½º °æ°è¿¡ °ÉÃÄ ¹è¿µÈ ¼ö ¾ø½À´Ï´Ù. ´ÙÀ½ ¿À·ù
±×¸² ¹×
¸¶½ºÅ© ¼Ó¼ºÀ» out-of-process °á°ú ¼³Á¤ÇÏ·Á°í ½ÃµµÇÕ´Ï´Ù.
·±Å¸ÀÓ ¿À·ù '-2147418113(8000ffff) ':
'_CommandBarButton' °³Ã¼ÀÇ ' ±×¸²' ¸Þ¼µå°¡ ½ÇÆÐÇß½À´Ï´Ù.
µû¶ó¼ ¸ðµç out-of-process ÀÚµ¿È Ŭ¶óÀÌ¾ðÆ®¿¡¼ ¶Ç´Â Visual Basic IDE µð¹ö±× ¸ðµå¿¡¼ ½ÇÇà ÁßÀÎ ÇÁ·Î¼¼½º ±¸¼º ¿ä¼Ò¿¡¼
CommandBarButton¿¡ ´ëÇØ ÀÌ·¯ÇÑ ¼Ó¼ºÀ» ¼³Á¤ÇÒ ¼ö ¾ø½À´Ï´Ù. Ãß°¡-Visual Basic IDE¿¡¼ ÀÌ ¹®¼¿¡ ¼³¸íµÇ¾î ÀÖ´Â ¿¹Á¦ ½ÇÇàÇÏ´Â °æ¿ì ÀÌ ¿À·ù¸¦ ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù. µð¹ö±ëÇÏ´Â µ¿¾È ¿À·ù°¡ ¹ß»ýÇÏÁö ¾Êµµ·Ï ÇÏ·Á¸é
±×¸² ¹×
¸¶½ºÅ© ¼Ó¼ºÀ» ¼³Á¤Çϰųª °°Àº Á¶°ÇºÎ ÄÄÆÄÀÏÀ» »ç¿ëÇÏ¿© ÁÙÀ» ÁÖ¼®À¸·Î ÀÖ´Â
# If... Then... #Else Áö½Ã¹®À».
ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
238228
(http://support.microsoft.com/kb/238228/
)
¾ø´Â Office 2000 COM Ãß°¡ ±â´É Visual BasicÀÇ ºôµå ¹æ¹ý
230689
(http://support.microsoft.com/kb/230689/
)
¿¹Á¦: Comaddin.exe Office 2000 COM Ãß°¡ Visual C++¿¡¼ ±â·ÏµÈ ±â´É
150034
(http://support.microsoft.com/kb/150034/
)
PRB: ÇÁ·Î¼¼½º °æ°è °£ LPPICTUREDISP ¼º°ø ¼ö ¾ø´Ù
ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ÂüÁ¶ÇϽʽÿÀ.
±â¼ú ÀÚ·á: 286460 - ¸¶Áö¸· °ËÅä: 2007³â 1¿ù 29ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 4.6
º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Visual Basic 6.0 Professional Edition
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Office Word 2003
- Microsoft Word 2002 Standard Edition
- Microsoft Office FrontPage 2003
- Microsoft FrontPage 2002 Standard Edition
- Microsoft Office Outlook 2003
- Microsoft Outlook 2002 Standard Edition
- Microsoft Office PowerPoint 2003
- Microsoft PowerPoint 2002 Standard Edition
| kbmt kbautomation kbhowto KB286460 KbMtko |
±â°è ¹ø¿ªµÈ ¹®¼Áß¿ä: º» ¹®¼´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼ ¹× ±â°è ¹ø¿ªµÈ ¹®¼¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼ ±â°è ¹ø¿ª ¹®¼¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.