Guest User

Untitled

a guest
Jan 22nd, 2018
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. <DnaLibrary Name="Sample Add-In" Language="CS" RuntimeVersion="v4.0">
  2. <Reference AssemblyPath="System.Windows.Forms.dll"/>
  3. <Reference Name="Microsoft.Office.Interop.Excel" />
  4. <![CDATA[
  5. using System;
  6. using ExcelDna.Integration;
  7. using System.Windows.Forms;
  8. using Excel = Microsoft.Office.Interop.Excel;
  9.  
  10. public class MyAddIn : IExcelAddIn
  11. {
  12.  
  13. public void AutoOpen()
  14. {
  15. Excel.Application XL = (Excel.Application)ExcelDnaUtil.Application;
  16. XL.OnKey("^p", "Macro_Test");
  17.  
  18. MessageBox.Show("Add-In Loaded.", "Add-In AutoOpen");
  19. }
  20.  
  21.  
  22. public void AutoClose()
  23. {
  24.  
  25. }
  26.  
  27. public static void Macro_Test()
  28. {
  29. MessageBox.Show("Macro Test", "Macro Test");
  30. }
  31.  
  32. }
  33. ]]>
  34. </DnaLibrary>
Add Comment
Please, Sign In to add comment