ÇÔ¸Õ¡ÒÃÊÃéÒ§¡Òà Office COM add-in ·Õè â´Âãªé Visual .NET c#

Microsoft Office XP, Microsoft Office 2003 áÅÐ Microsoft Office 2007 ʹѺʹعʶһѵ¡ÃÃÁ¢Í§µÑÇÍ͡Ẻà´ÕÂÇÊÓËÃѺ¡ÒÃÊÃéÒ§â»Ãá¡ÃÁ»ÃÐÂØ¡µìà¾ÔèÁàµÔÁ à¾×èÍà¾ÔèÁ»ÃÐÊÔ·¸ÔÀÒ¾ áÅФǺ¤ØÁâ»Ãá¡ÃÁ»ÃÐÂØ¡µì Office â»Ãá¡ÃÁàËÅèÒ¹Õéà¾ÔèÁàµÔÁ¨ÐàÃÕ¡ÇèÒẺ¨ÓÅͧÇѵ¶Ø¤ÍÁâ¾à¹¹µì¢Í§ Microsoft (COM) ¤§¤Åѧ·Õèà¾ÔèÁ¢Öé¹ º·¤ÇÒÁ·ÕèÁÕ¡Ò÷ÕÅТÑ鹵͹¹Õé͸ԺÒÂà¡ÕèÂǡѺâ»Ãá¡ÃÁ Office COM à¾ÔèÁàµÔÁ áÅÐ͸ԺÒ¶֧ÇÔ¸Õ¡ÒÃÊÃéÒ§¢éÍ Office COM add-in ·Õè â´Âãªé Microsoft Visual c# .NET

ÍÔ¹à·ÍÃìà¿« IDTExensibility2

ÁÕ COM add-in ·Õè¹Õèà»ç¹à«ÔÃì¿àÇÍÃì COM 㹡ÒûÃÐÁÇżŠËÃ×ÍÃÒ ActiveX àª×èÍÁâ§Ẻ䴹ÒÁÔ¡ÃÕ (DLL), ·Õèãªé¹Ñé¹IDTExensibility2ÍÔ¹à·ÍÃìà¿«µÒÁ·Õè͸ԺÒÂäÇéã¹äźÃÒÃբͧª¹Ô´ Microsoft à¾ÔèÁã¹â»Ãá¡ÃÁÍÍ¡ (Msaddndr.dll) Ê׺·Í´ÁÒ¨Ò¡ÍÔ¹à·ÍÃìà¿«¹Õé áÅеéͧ»¯ÔºÑµÔµÒÁÇÔ¸Õ·Õè 5 ¢Í§áµèÅÐâ»Ãá¡ÃÁ·Ñé§ËÁ´ COM à¾ÔèÁàµÔÁ

OnConnection

¡Ãкǹ¡ÒÃOnConnectionà˵ءÒóì fires ·Ø¡¤ÃÑé§ COM add-in ·ÕèÁÕ¡ÒÃàª×èÍÁµèÍ ¡ÒÃà¾ÔèÁà¢éÒÍÒ¨ÍÂèÒ§§èÒÂÁÕ¡ÒÃàª×èÍÁµèÍàÁ×èÍàÃÔèÁµé¹ â´Â¼Ùéãªé ËÃ×ͼèÒ¹ ·Ò§¡Ò÷ӧҹÍѵâ¹ÁÑµÔ ¶éÒ¡ÒÃOnConnectionà˵ءÒóì¡ÅѺàÊÃç¨àÃÕºÃéÍÂáÅéÇ ¡ÒÃà¾ÔèÁà¢éÒà»ç¹ said à¾×èÍãËéÊÒÁÒöâËÅ´ ¶éÒÁÕ¡ÒÃÊ觤׹¢éͼԴ¾ÅÒ´ á;ÅÔपѹâÎʵìÍÍ¡¢Í§¡ÒÃÍéÒ§ÍÔ§ä»à¾ÔèÁà¢éÒ㹷ѹ·Õ áÅÐÇѵ¶Ø¶Ù¡·ÓÅÒÂ

¡Ãкǹ¡ÒÃOnConnectionà˵ءÒóì¾ÒÃÒÁÔàµÍÃì·Ñé§ÊÕèµèÍ仹Õé:

• â»Ãá¡ÃÁ»ÃÐÂØ¡µì: ¡ÒÃÍéÒ§ÍÔ§ä»ÂѧÇѵ¶Øâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§âÎʵì
• ConnectMode: Ẻ¤èÒ¤§·ÕèÃкØÇÔ¸Õ¡ÒÃà¾ÔèÁäÇéÁÕ¡ÒÃàª×èÍÁµèÍ ¡ÒÃà¾ÔèÁà¢éÒÊÒÁÒöàª×èÍÁµèÍ´éÇÂÇÔ¸Õ¡ÒôѧµèÍ仹Õé:
  • ext_cm_AfterStartup: àÃÔèÁµé¹¡ÒÃà¾ÔèÁà»ç¹¢Öé¹ â´Â¼Ùéãªé¨Ò¡¹Ñé¹â»Ãá¡ÃÁ COM à¾ÔèÁàµÔÁ¡ÅèͧâµéµÍº
  • ext_cm_CommandLine: ¡ÒÃà¾ÔèÁäÇéÁÕ¡ÒÃàª×èÍÁµèͨҡºÃ÷Ѵ¤ÓÊÑè§ â»Ã´ÊѧࡵÇèÒ ¹ÕéäÁèÊÒÁÒöãªé㹡ÒÃÊÃéÒ§â»Ãá¡ÃÁ COM à¾ÔèÁàµÔÁÊÓËÃѺâ»Ãá¡ÃÁ»ÃÐÂØ¡µì Office
  • ext_cm_External: àª×èÍÁµèÍ¡ÒÃà¾ÔèÁà»ç¹ÍÂÙè â´Ââ»Ãá¡ÃÁ»ÃÐÂØ¡µìÀÒ¹͡â´ÂÍѵâ¹ÁÑµÔ â»Ã´ÊѧࡵÇèÒ ¹ÕéäÁèÊÒÁÒöãªé㹡ÒÃÊÃéÒ§â»Ãá¡ÃÁ COM à¾ÔèÁàµÔÁÊÓËÃѺ Office áÍ»¾ÅÔपѹ
  • ext_cm_Startup: àÃÔèÁµé¹¡ÒÃà¾ÔèÁà¢éÒ¢Öé¹ â´Â¡ÒÃâÎʵìàÁ×èÍàÃÔèÁµé¹â»Ãá¡ÃÁ»ÃÐÂØ¡µì ÅѡɳСÒ÷ӧҹ¹Õé¶Ù¡¤Çº¤ØÁ â´Â¡ÒõÑ駤èÒã¹ÃÕ¨ÔÊ·ÃÕ
• AddInInst: ¡ÒÃÍéÒ§ÍÔ§ä»ÂѧCOMAddInÇѵ¶Ø·ÕèÍéÒ§ÍÔ§¶Ö§¹Õé add-in ã¹·Õè¹ÕéCOMAddIns¤ÍÅàÅ¡ªÑ¹ÊÓËÃѺá;ÅÔपѹ¢Í§âÎʵì
• ¡Ó˹´àͧ: ÍÒÃìàÃÂì¢Í§µÑÇá»Ã¾ÔÁ¾ì¤èÒ·ÕèÊÒÁÒöà¡çº¢éÍÁÙÅ·Õè¡Ó˹´â´Â¼Ùéãªé

OnDisconnection

¡Ãкǹ¡ÒÃOnDisconnectionà˵ءÒóì fires àÁ×èÍ¡Òà COM add-in ·Õè¶Ù¡µÑ´ áÅÐà¾Õ§á¤è ¡è͹·Õè¨Ð unloads ¨Ò¡Ë¹èǤÇÒÁ¨Ó ¡ÒÃà¾ÔèÁà¢éÒ¤Ç÷ӡÒÃÅéÒ§¢éÍÁÙÅã´ æ ¢Í§·ÃѾÂÒ¡Ãã¹à˵ءÒóì¹Õé áÅФ׹¤èÒ¡ÒÃà»ÅÕè¹á»Å§ã´ æ ·Õè·Óá;¾ÅÔपѹâÎʵì

¡Ãкǹ¡ÒÃOnDisconnectionà˵ءÒóìÊͧ¾ÒÃÒÁÔàµÍÃìµèÍ仹Õé:

• RemoveMode: Ẻ¤èÒ¤§·ÕèÃкØÇÔ¸Õ¡ÒÃà¾ÔèÁäÇé¶Ù¡µÑ´ ¡ÒÃà¾ÔèÁã¹ÊÒÁÒö¶Ù¡µÑ´´éÇÂÇÔ¸Õ¡ÒôѧµèÍ仹Õé:
  • ext_dm_HostShutdown: ¡àÅÔ¡¡ÒÃà¾ÔèÁà¢éÒà»ç¹µèÍàÁ×èͻԴâ»Ãá¡ÃÁ»ÃÐÂØ¡µìâÎʵì
  • ext_dm_UserClosed: ¡ÒÃà¾ÔèÁäÇé¶Ù¡µÑ´ â´Â¼ÙéãªéËÃ×Í¡Ò÷ӧҹÍѵâ¹ÁѵԵÑǤǺ¤ØÁ
• ¡Ó˹´àͧ: ÍÒÃìàÃÂì¢Í§µÑÇá»Ã¾ÔÁ¾ì¤èÒ·ÕèÊÒÁÒöà¡çº¢éÍÁÙÅ·Õè¡Ó˹´â´Â¼Ùéãªé

OnAddInsUpdate

¡Ãкǹ¡ÒÃOnAddInsUpdateà˵ءÒóì fires àÁ×èͪش¢Í§¡ÒÃŧ·ÐàºÕ¹ COM ¤§¤Åѧ·Õèà¾ÔèÁ¡ÒÃà»ÅÕè¹á»Å§ ã¹ÍÂèÒ§Í×è¹ ·Ø¡¤ÃÑé§ COM ¶Ù¡µÔ´µÑé§ ËÃ×ÍàÍÒÍÍ¡¨Ò¡â»Ãá¡ÃÁ»ÃÐÂØ¡µìâÎʵì à˵ءÒóì¹Õé fires

OnStartupComplete áÅÐ OnBeginShutdown

·Ñé§ÊͧẺOnStartupCompleteÇÔ¸Õ¡Òà áÅÐOnBeginShutdownÁÕàÃÕ¡ÇÔ¸ÕàÁ×èÍâ»Ãá¡ÃÁ»ÃÐÂØ¡µìâÎʵìä´éÍÍ¡¨Ò¡ ËÃ×ÍÁÕ¡Òûé͹ʶҹÐã¹¼Ùé·ÕèãªéâµéµÍº¤Çö١ avoided à¹×èͧ¨Ò¡â»Ãá¡ÃÁ»ÃÐÂØ¡µìäÁèÇèÒ§¡ÓÅѧâËÅ´ ËÃ×Í unloading àͧ¨Ò¡Ë¹èǤÇÒÁ¨Ó ¡Ãкǹ¡ÒÃOnStartupCompleteÁÕàÃÕ¡ÇÔ¸Õ¡çµèÍàÁ×èÍàª×èÍÁµèÍà¾ÔèÁà¢éÒÁÕÍÂÙèã¹ÃÐËÇèÒ§¡ÒÃàÃÔèÁµé¹ áÅÐOnBeginShutdownÁÕàÃÕ¡ÇÔ¸Õ੾ÒÐ㹡óշÕèâÎʵì disconnects à¾ÔèÁà¢éÒã¹ÃÐËÇèÒ§¡ÒûԴÃкº

à¹×èͧ¨Ò¡ÍÔ¹à·ÍÃìà¿«ÊÓËÃѺ¼ÙéãªéÊÓËÃѺâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§âÎʵì·Ñé§ËÁ´·Õèãªé§Ò¹àÁ×èÍ´Óà¹Ô¹¡ÒÃà˵ءÒóìàËÅèÒ¹Õé àËÅèÒ¹Ñé¹ÍÒ¨à»ç¹ÇÔ¸Õà´ÕÂÇ·Õè¨Ð·Ó¡ÒôÓà¹Ô¹¡ÒúҧÍÂèÒ§·ÕèÁԩйÑé¹ ¨ÐäÁè¾ÃéÍÁãªé§Ò¹¨Ò¡¹Ñé¹OnConnectionà˵ءÒóìáÅÐOnDisconnectionà˵ءÒóì

COM add-in ·Õèŧ·ÐàºÕ¹

¹Í¡à˹×ͨҡ¡ÒÃŧ·ÐàºÕ¹ COM »¡µÔ ¡Òà COM add-in ·Õèµéͧ¡ÒÃ㹡ÒÃŧ·ÐàºÕ¹µÑÇàͧ ´éÇÂâ»Ãá¡ÃÁ»ÃÐÂØ¡µì Office áµèÅзÕè¨ÐÃѹ àÁ×è͵éͧ¡ÒÃŧ·ÐàºÕ¹µÑÇàͧ ´éÇÂâ»Ãá¡ÃÁ»ÃÐÂØ¡µì·Õè੾ÒÐ ¡ÒÃà¾ÔèÁà¢éÒ¤ÇÃÊÃéÒ§¤ÕÂìÂèÍ ¡ÒÃãªé ProgID ¢Í§ª×èÍÊÓËÃѺ¤ÕÂì ÀÒÂãµéµÓá˹觷ÕèµÑ駵èÍ仹Õé:¡ÒÃà¾ÔèÁã¹ÊÒÁÒöãËé¤èÒã¹µÓá˹觹Õé¤ÕÂìÊÓËÃѺª×èÍ·ÕèãªéáÊ´§·Õè¨Ó§èÒÂáÅФÓ͸ԺÒÂàµçÁ ¹Í¡¨Ò¡¹Õé ¡ÒÃà¾ÔèÁà¢éÒ¤ÇÃÃкØÅѡɳСÒ÷ӧҹ·ÕèµéͧâËÅ´¡Òà â´Âãªé¤èÒ DWORD ·Õèª×èÍ LoadBehavior ¤èÒ¹Õé¡Ó˹´ÇÔ¸Õ¡ÒÃà¾ÔèÁà¢éÒ¶Ù¡âËÅ´ â´Ââ»Ãá¡ÃÁ»ÃÐÂØ¡µìâÎʵì áÅШѴ·Ó¢Ö鹢ͧªØ´¢Í§¤èÒµèÍ仹Õé:

• 0 = Disconnect - ¶Ù¡âËÅ´äÁè
• 1 = Connected - ¶Ù¡âËÅ´
• 2 = bootload - âËÅ´àÁ×èÍàÃÔèÁµé¹â»Ãá¡ÃÁ»ÃÐÂØ¡µì
• 8 = demandLoad - âËÅ´àÁ×èÍ¡ÒÃÃéͧ¢Í â´Â¼Ùéãªé
• 16 = ConnectFirstTime - âËÅ´à¾Õ§¤ÃÑé§à´ÕÂÇ (㹡ÒÃàÃÔèÁµé¹¶Ñ´ä»)

¤èÒ·ÑèÇä»·ÕèÃкض١ 0x03 (Connected | Bootload)

â»Ãá¡ÃÁà¾ÔèÁàµÔÁ·Õè¹ÓÁÒãªéIDTExtensibility2¹Í¡¨Ò¡¹Õé¤ÇÃÃкؤèÒ DWORD ·ÕèàÃÕ¡ÇèÒàÁ×è͵éͧ¡Òú觪ÕéÇèÒ à¾ÔèÁ-¤§¤Åѧ»ÅÍ´ÀÑÂÊÓËÃѺ¡ÒôÓà¹Ô¹¡Ò÷ÕèäÁèʹѺʹعÍÔ¹à·ÍÃìà¿«¢Í§¼Ùéãªé ¤èҢͧ 0x00 ºè§ªÕéà·ç¨ áÅФèÒ 0x01 ºè§ªÕéÇèÒ True

ÇÔ¸Õ¡ÒÃÊÃéҧẺ COM add-in ·Õè â´Âãªé Visual .NET c#

µÒÁ·Õè¡ÅèÒǶ֧¡è͹˹éÒ ¡Òà Office COM add-in ·ÕèÁÕ COM 㹡Ãкǹ¡ÒÃà«ÔÃì¿àÇÍÃì·ÕèÁÕ¡ÒÃàÃÕ¡ãªé â´Ââ»Ãá¡ÃÁ»ÃÐÂØ¡µì Office ¼èÒ¹àÅàÂÍÃìàÇÅÒÃѹ¢Í§ COM ´Ñ§¹Ñé¹ ¡ÒþѲ¹ÒẺ COM add-in ã¹.NET µéͧÇèÒ Êèǹ»ÃСͺà¾ÔèÁ㹶١¹ÓÁÒãªéã¹.NET áÅÐà»Ô´à¼Âä»Âѧä¤Åà͹µì¢Í§ COM (¹Ñ蹤×Í â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ Office) ¶Ö§ªÑé¹ interop COM

àÁ×è͵éͧ¡ÒÃÊÃéҧẺ COM add-in ·Õèã¹ Visual .NET c# ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:

1. ã¹ Visual c# .NET ÊÃéÒ§äźÃÒÃբͧÃдѺªÑé¹â¤Ã§¡ÒÃ
2. à¾ÔèÁ¡ÒÃÍéÒ§ÍÔ§ä»ÂѧäźÃÒÃÕª¹Ô´·ÕèãªéIDTExtensibility2. áÍÊà«ÁºÅÕ interop ËÅÑ¡ÊÓËÃѺ«Öè§ÁÕÍÂÙèáÅéÇÀÒÂãµéª×èÍextensibility.
3. à¾ÔèÁ¡ÒÃÍéÒ§ÍÔ§ä»ÂѧäźÃÒÃÕÇѵ¶Ø Microsoft Office áÍÊà«ÁºÅÕ interop ËÅÑ¡ÊÓËÃѺ«Öè§ÁÕÍÂÙèáÅéÇÀÒÂãµéª×èÍOffice.
4. ÊÃéÒ§¤ÅÒÊ·ÕèÊÒ¸ÒóÐã¹äźÃÒÃÕ¤ÅÒÊ·ÕèãªéIDTExtensibility2.
5. ËÅѧ¨Ò¡¡ÒÃà»ç¹¤ÅÒÊ ÊÃéÒ§äźÃÒÃÕ ¡ÒÃŧ·ÐàºÕ¹ã¹äźÃÒÃÕ COM interop àÁ×è͵éͧ¡Ò÷Óàªè¹¹Õé ÊÃéÒ§ÃÑ´¡ØÁª×èÍáÍÊà«ÁºÅÕÊÓËÃѺäźÃÒÃÕ¤ÅÒʹÕé áÅзӡÒÃŧ·ÐàºÕ¹äÇé¡Ñº COM interop ¤Ø³ÊÒÁÒöãªé Regasm.exe ¡ÒÃŧ·ÐàºÕ¹¤ÍÁâ¾à¹¹µì.NET ÊÓËÃѺ COM interop
6. ÊÃéÒ§ÃÒ¡ÒÃÃÕ¨ÔÊ·ÃÕà¾×èÍãËéâ»Ãá¡ÃÁ»ÃÐÂØ¡µì Office ÃÙé¨Ñ¡ áÅÐÊÒÁÒöâËÅ´¡ÒÃà¾ÔèÁäÇé

¤Ø³ÊÒÁÒöàÅ×Í¡·Õè¨Ð´Óà¹Ô¹¡ÒâÑ鹵͹àËÅèÒ¹Õé·Ñé§ËÁ´ ËÃ×ͤسÊÒÁÒöÊÃéÒ§â¤Ã§¡ÒÃ.NET ª¹Ô´Addin ·ÕèãªéÃèÇÁ¡Ñ¹. «Öè§àÃÔèÁµé¹µÑǪèÇ Extensibility «Ö觪èǤسÊÃéÒ§¡Òà COM à¾ÔèÁà¢éÒã¹.NET

µÑǪèÇÂÊÃéÒ§¡Òà Extensibility ÊÃéÒ§à»ç¹ Visual c# .NET â¤Ã§¡ÒÃäźÃÒÃÕ¤ÅÒʾÃéÍÁ´éǤÓàª×èÍÁµèͤÅÒÊ·Õèãªé¹Ñé¹IDTExtensibility2ÍÔ¹à·ÍÃìà¿« ÃËÑÊ skeleton ·Õèãªé¡ÑºÊÁÒªÔ¡·ÕèÇèÒ§¢Í§IDTExtensibility¹Í¡¨Ò¡¹ÕéÊÃéÒ§¢Öé¹ â¤Ã§¡ÒùÕéÁÕ¡ÒÃÍéÒ§ÍÔ§áÍÊà«ÁºÅÕ Extensibility áÅÐ Office ¡ÒõÑ駤èÒâ¤Ã§ÊÃéÒ§¢Í§â¤Ã§¡ÒÃä´éŧ·ÐàºÕ¹ÊÓËÃѺ Interop COMàÅ×Í¡ á¿éÁ¤ÕÂì (.snk) ¢Í§áÍÊà«ÁºÅÕ·Õè¶Ù¡ÊÃéÒ§¢Öé¹ áÅÐÁÕ¡ÒÃÍéÒ§Íԧ㹹Ñé¹AssemblyKeyfileá͵·ÃÔºÔǵìã¹ Assemblyinfo.vb

¾ÃéÍÁ¡Ñºâ¤Ã§¡ÒÃäźÃÒÃÕ¤ÅÒÊ ÇÔ«ÒÃì´ÊÃéÒ§â¤Ã§¡ÒáÒõÑ駤èÒ·Õè¤Ø³ÊÒÁÒöãªéà¾×èÍ»ÃѺãªé COM à¾ÔèÁäÇ麹¤ÍÁ¾ÔÇàµÍÃìà¤Ã×èͧÍ×è¹ ¤Ø³ÍҨźâ¤Ã§¡ÒùÕéËÒ¡µéͧ¡ÒÃ

µÑÇÍÂèÒ§áµèÅТÑ鹵͹

1. 㹡ÒÃá¿éÁ:¤ÅÔ¡·ÕèàÁ¹Ùã¹ Microsoft Visual Studio .NETãËÁèáÅéÇ ¤ÅÔ¡Project.
2. 㹡ÒÃâ¤Ã§¡ÒÃãËÁè¡ÅèͧâµéµÍº¡Åèͧ ¢ÂÒÂâ¤Ã§¡ÒÃÍ×è¹ÀÒÂãµéª¹Ô´â¤Ã§¡ÒÃàÅ×Í¡â¤Ã§¡Òà extensibilityáÅéÇ àÅ×Í¡¹Ñé¹ãªéÃèÇÁ¡Ñ¹à¾ÔèÁäÇéáÁèẺ:
3. »ÃÐàÀ·:MyCOMAddinª×èÍ ¢Í§¡ÒÃà¾ÔèÁ-ã¹'áÅÐ'áÅéǤÅÔ¡µ¡Å§.
4. àÁ×è͵ÑǪèÇÂÊÃéÒ§¡Òà Extensibility »ÃÒ¡¯ ·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹Õé:
   1. º¹Ë¹éÒ 1 ¡ÒÃàÅ×Í¡ÊÃéÒ§¡ÒÃà¾ÔèÁà¢éÒâ´Âãªé Visual c#áÅéÇ ¤ÅÔ¡¶Ñ´ä».
   2. º¹Ë¹éÒ 2 àÅ×Í¡â»Ãá¡ÃÁ»ÃÐÂØ¡µìµèÍ仹Õé¢Í§âÎʵì áÅФÅÔ¡¶Ñ´ä»:
      • Microsoft Word
      • Microsoft PowerPoint
      • Microsoft Outlook
      • Microsoft Excel
      • Microsoft Access
   3. º¹Ë¹éÒ 3 ª×èÍáÅФÓ͸ԺÒÂÊÓËÃѺ¡ÒÃà¾ÔèÁà¢éÒ áÅШҡ¹Ñé¹ ¤ÅÔ¡¶Ñ´ä».
      
      ËÁÒÂà˵Ø:ª×èÍáÅФÓ͸ԺÒ¢ͧ¡ÒÃà¾ÔèÁäÇé»ÃÒ¡¯¢Öé¹ã¹¡ÒÃCOM à¾ÔèÁäÇé¡ÅèͧâµéµÍºã¹â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ Office
      
      
   4. º¹Ë¹éÒ 4 àÅ×Í¡µÑÇàÅ×Í¡·Õè¾ÃéÍÁãªé§Ò¹·Ñé§ËÁ´ áÅФÅÔ¡¶Ñ´ä».
   5. ¤ÅÔ¡àÊÃç¨ÊÔé¹.
5. 㹡ÒÃProjectàÁ¹Ù ¤ÅÔ¡à¾ÔèÁ¡ÒÃÍéÒ§ÍÔ§. ¤ÅÔ¡System.Windows.Forms.DLLã¹ÃÒ¡ÒÃÊèǹ»ÃСͺ ¤ÅÔ¡àÅ×Í¡áÅéÇ ¤ÅÔ¡µ¡Å§.
6. à¾ÔèÁµèÍ仹Õéŧã¹ÃÒ¡Òâͧ namespaces ã¹¹Ñé¹àª×èÍÁµèͤÅÒÊ:

   using System.Reflection;

7. à¾ÔèÁÊÁÒªÔ¡µèÍ仹Õéä»àª×èÍÁµèͤÅÒÊ:

   private CommandBarButton MyButton; 

8. ãªéÃËÑÊÊÓËÃѺÊÁÒªÔ¡¢Í§IDTExtensibility2㹡ÒÃàª×èÍÁµèͤÅÒ ´Ñ§:

   public void OnConnection(object application, Extensibility.ext_ConnectMode connectMode, object addInInst, ref System.Array custom) {
      applicationObject = application;
      addInInstance = addInInst;
   
      if(connectMode != Extensibility.ext_ConnectMode.ext_cm_Startup)
      {
         OnStartupComplete(ref custom);
      }
   
   }
   
   public void OnDisconnection(Extensibility.ext_DisconnectMode disconnectMode, ref System.Array custom) {
      if(disconnectMode != Extensibility.ext_DisconnectMode.ext_dm_HostShutdown)
      {
         OnBeginShutdown(ref custom);
      }
      applicationObject = null;
   }
   
   
   public void OnAddInsUpdate(ref System.Array custom)
   {
   }
   
   public void OnStartupComplete(ref System.Array custom)
   {
      CommandBars oCommandBars;
      CommandBar oStandardBar;
   
      try
      {
      oCommandBars = (CommandBars)applicationObject.GetType().InvokeMember("CommandBars", BindingFlags.GetProperty , null, applicationObject ,null);
      }
      catch(Exception)
      {
      // Outlook has the CommandBars collection on the Explorer object.
      object oActiveExplorer;
      oActiveExplorer= applicationObject.GetType().InvokeMember("ActiveExplorer",BindingFlags.GetProperty,null,applicationObject,null);
      oCommandBars= (CommandBars)oActiveExplorer.GetType().InvokeMember("CommandBars",BindingFlags.GetProperty,null,oActiveExplorer,null);
      }
   
      // Set up a custom button on the "Standard" commandbar.
      try
      {
      oStandardBar = oCommandBars["Standard"];        
      }
      catch(Exception)
      {
      // Access names its main toolbar Database.
      oStandardBar = oCommandBars["Database"];      
      }
   
      // In case the button was not deleted, use the exiting one.
      try
      {
      MyButton = (CommandBarButton)oStandardBar.Controls["My Custom Button"];
      }
      catch(Exception)
      {
         object omissing = System.Reflection.Missing.Value ;
         MyButton = (CommandBarButton) oStandardBar.Controls.Add(1, omissing , omissing , omissing , omissing);
         MyButton.Caption = "My Custom Button";
         MyButton.Style = MsoButtonStyle.msoButtonCaption;
      }
   
      // The following items are optional, but recommended. 
      //The Tag property lets you quickly find the control 
      //and helps MSO keep track of it when more than
      //one application window is visible. The property is required
      //by some Office applications and should be provided.
      MyButton.Tag = "My Custom Button";
   
      // The OnAction property is optional but recommended. 
      //It should be set to the ProgID of the add-in, so that if
      //the add-in is not loaded when a user presses the button,
      //MSO loads the add-in automatically and then raises
      //the Click event for the add-in to handle. 
      MyButton.OnAction = "!<MyCOMAddin.Connect>";
   
      MyButton.Visible = true;
      MyButton.Click += new Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(this.MyButton_Click);
   
   
      object oName = applicationObject.GetType().InvokeMember("Name",BindingFlags.GetProperty,null,applicationObject,null);
   
      // Display a simple message to show which application you started in.
      System.Windows.Forms.MessageBox.Show("This Addin is loaded by " + oName.ToString()   , "MyCOMAddin");
      oStandardBar = null;
      oCommandBars = null;
   }
   
   public void OnBeginShutdown(ref System.Array custom)
   {
      object omissing = System.Reflection.Missing.Value ;
      System.Windows.Forms.MessageBox.Show("MyCOMAddin Add-in is unloading.");
      MyButton.Delete(omissing);
      MyButton = null;
   }
   
   private void MyButton_Click(CommandBarButton cmdBarbutton,ref bool cancel) {
      System.Windows.Forms.MessageBox.Show("MyButton was Clicked","MyCOMAddin"); }
   					

9. ÊÃéÒ§ áÅз´Êͺ¡Òà COM add-in ·Õè â´ÂãËé·ÓµÒÁ¢Ñ鹵͹µèÍ仹Õé::
   1. 㹡ÒáÒÃÊÃéÒ§àÁ¹Ù ¤ÅÔ¡ÊÃéÒ§â«Å٪ѹ. ËÁÒÂà˵Øŧ·Õè ÊÃéҧ㹠COM add-in ·Õè·ÐàºÕ¹¤ÅÒ.NET ´éÇ COM interop
   2. àÃÔèÁâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ Office ·Õè¤Ø³àÅ×Í¡à»ç¹â»Ãá¡ÃÁ»ÃÐÂØ¡µì¡ÒÃâÎʵìÊÓËÃѺ¢Í§¤Ø³à¾ÔèÁäÇé (µÑÇÍÂèÒ§àªè¹ Microsoft Word ËÃ×Í Microsoft Excel) ÍÂèÒ§ã´ÍÂèҧ˹Öè§
   3. ËÅѧ¨Ò¡à¾ÔèÁà¢éÒä´éàÃÔèÁµé¹ ¡ÒÃOnStartupCompleteà˵ءÒóì¢Í§¡ÒÃà¾ÔèÁà¢éÒà»ç¹ fired áÅФسä´éÃѺ¢éͤÇÒÁáÊ´§¢éͤÇÒÁ ¡àÅÔ¡¡Åèͧ¢éͤÇÒÁ â»Ã´ÊѧࡵÇèÒ ¡ÒÃà¾ÔèÁäÇéà¾ÔèÁ»ØèÁẺ¡Ó˹´àͧãËÁè ´éǤÓ͸ԺÒÂ੾ÒÐ "¢Í§©Ñ¹¡Ó˹´àͧ»ØèÁ" ä»Âѧᶺà¤Ã×èͧÁ×ÍÁҵðҹ
   4. ¤ÅÔ¡»ØèÁẺ¡Ó˹´àͧ¢Í§©Ñ¹. ¡Ãкǹ¡ÒäÅÔ¡à˵ءÒóìÊÓËÃѺ»ØèÁ¶Ù¡¨Ñ´¡Òà â´Â¡ÒÃà¾ÔèÁäÇé áÅФسä´éÃѺ¡Åèͧ¢éͤÇÒÁ ¡àÅÔ¡¡Åèͧ¢éͤÇÒÁ
   5. ÍÍ¡¨Ò¡â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ Office
   6. àÁ×èͤسÍÍ¡¨Ò¡â»Ãá¡ÃÁ»ÃÐÂØ¡µìOnBeginShutDownfires à˵ءÒóì áÅФسä´éÃѺ¢éͤÇÒÁ ¡àÅÔ¡¡Åèͧ¢éͤÇÒÁÊÔé¹ÊØ´¡ÒÃÊÒ¸Ôµ

ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺ¡ÒÃà¢Õ¹â»Ãá¡ÃÁ COM à¾ÔèÁàµÔÁ ãËé¤ÅÔ¡ËÁÒÂàÅ¢º·¤ÇÒÁµèÍ仹Õéà¾×èÍ´Ùº·¤ÇÒÁã¹°Ò¹¤ÇÒÁÃÙé¢Í§ Microsoft: