protected void AddMenu(ref Office.CommandBarButton btn, Office.CommandBar bar,
			string strCaption, string strTooltip,
			Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler handler)
		{
			btn = (Office.CommandBarButton)bar.Controls.Add(Office.MsoControlType.msoControlButton, missing, missing, missing, true);
			AddMenu(btn, strCaption, strTooltip, handler);
		}

        public void onRegButton(Office.IRibbonControl control)
        {
            Excel.Application exApp = Globals.ThisAddIn.Application as Excel.Application;
            Excel.Workbook wb = exApp.ActiveWorkbook as Excel.Workbook ;
            string filename = wb.Name.ToString();

            Microsoft.Office.Core.DocumentProperties properties;
            properties = (Office.DocumentProperties)wb.CustomDocumentProperties;

            Channel ch = new Channel();
            ch.setAuthToken(TokenStore.getTokenFromStore());

            if (ch.checkSpreadSheetID(wb) == "0")
            {

                string fileID = ch.getSpreadSheetID(filename);
                MessageBox.Show(fileID, "File ID");

                properties.Add("Excalibur ID", false,
                    Microsoft.Office.Core.MsoDocProperties.msoPropertyTypeString, fileID);
            }
            else
            {
                MessageBox.Show("ID Exists - Excalibur ID: " + ch.checkSpreadSheetID(wb), "File Already Registered");
            }
        }

        //Create callback methods here. For more information about adding callback methods, select the Ribbon XML item in Solution Explorer and then press F1

        public void RibbonLoad(Office.IRibbonUI ribbonUi)
        {
            _ribbon = ribbonUi;

            SetVoicesFromInstalledOptions();
            SetCoreVoicesToSelections();
        }

 void HighlightTextRange(Office.TextRange2 textRange, Core.Parser parser)
 {
     textRange.Font.Fill.ForeColor.RGB = System.Drawing.Color.Black.ToMsoColor();
     foreach (var f in parser.Parse(textRange.Text))
     {
         // NOTE: indices of Characters are 1-based
         textRange.get_Characters(1 + f.Start, f.Length).Font.Fill.ForeColor.RGB = f.ForegroundColor.ToMsoColor();
     }
 }

        private static List<PowerPoint.Shape> GetShapesFromLinesInText(PowerPointSlide currentSlide, Office.TextRange2 text, PowerPoint.Shape shape)
        {
            List<PowerPoint.Shape> shapesToAnimate = new List<PowerPoint.Shape>();

            foreach (Office.TextRange2 line in text.Lines)
            {
                PowerPoint.Shape highlightShape = currentSlide.Shapes.AddShape(
                    Office.MsoAutoShapeType.msoShapeRoundedRectangle,
                    line.BoundLeft,
                    line.BoundTop,
                    line.BoundWidth,
                    line.BoundHeight);

                highlightShape.Adjustments[1] = 0.25f;
                highlightShape.Fill.ForeColor.RGB = Utils.Graphics.ConvertColorToRgb(backgroundColor);
                highlightShape.Fill.Transparency = 0.50f;
                highlightShape.Line.Visible = Office.MsoTriState.msoFalse;
                Utils.Graphics.MoveZToJustBehind(highlightShape, shape);
                highlightShape.Name = "PPTLabsHighlightTextFragmentsShape" + Guid.NewGuid().ToString();
                highlightShape.Tags.Add("HighlightTextFragment", highlightShape.Name);
                highlightShape.Select(Office.MsoTriState.msoFalse);
                shapesToAnimate.Add(highlightShape);
            }

            return shapesToAnimate;
        }

        void writeToText_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault)
        {
            try
            {
                System.DateTime currentDateTime = System.DateTime.Now;
                string dateStamp = currentDateTime.ToString("yyyyMMdd");

                string fileName =
                    System.Environment.GetFolderPath
                    (Environment.SpecialFolder.MyDocuments) + "\\\\" + dateStamp + ".txt";
                System.IO.StreamWriter sw = new System.IO.StreamWriter(fileName);

                foreach (Excel.Range cell in selectedCells.Cells)
                {
                    if (cell.Value2 != null)
                    {
                        sw.WriteLine(cell.Value2.ToString());
                    }
                }
                sw.Close();
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }
        }

        public FormAnswerOrder(Office.CustomXMLPart answersPart, Office.CustomXMLPart questionsPart)
        {
            InitializeComponent();

            // To populate the tree view, we need to traverse
            // the answers.  We could do this at the DOM level,
            // or using our answers object.
            // Best to use our answers object.

            this.answersPart = answersPart;
            answersObj = new answers();
            OpenDope_AnswerFormat.answers.Deserialize(answersPart.XML, out answersObj);

            // We want to show the question text in the tree view
            questionnaire = new questionnaire();
            questionnaire.Deserialize(questionsPart.XML, out questionnaire);

            ImageList TreeviewIL = new ImageList();
            TreeviewIL.Images.Add(System.Drawing.Image.FromStream(
                System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("OpenDope_AnswerFormat.folder.png")));
            TreeviewIL.Images.Add(System.Drawing.Image.FromStream(
                System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("OpenDope_AnswerFormat.Icons.LogicTree.variable_chevron.png")));
            TreeviewIL.Images.Add(System.Drawing.Image.FromStream(
                System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("OpenDope_AnswerFormat.Icons.LogicTree.repeat.png")));
            this.treeView1.ImageList = TreeviewIL;

            addNodes(answersObj.Items, root);
            this.treeView1.Nodes.Add(root);
            root.ImageIndex = 0;
            root.SelectedImageIndex = 0;

            treeView1.ExpandAll();
        }

 void taggerMenuItem_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault)
 {
     //TagWindow win = new TagWindow();
     //TagWindowWpf win = new TagWindowWpf();
     var win = new TestWpfApp.MainWindow();
     win.Show();
 }

 void Application_ItemContextMenuDisplay(Office.CommandBar CommandBar, Outlook.Selection Selection)
 {
     if (Selection[1] is Outlook.MailItem)
     {
         OnMailItenContextMenu(CommandBar, Selection);
     }
 }

        private Office.CommandBarButton CreateCommandBarButton(
            Office.CommandBar commandBar, string captionText, string tagText,
            string tipText, Office.MsoButtonStyle buttonStyle, System.Drawing.Bitmap picture,
            bool beginGroup, bool isVisible, object objBefore, Office._CommandBarButtonEvents_ClickEventHandler handler)
        {
            // Determine if button exists
            Office.CommandBarButton aButton = (Office.CommandBarButton)
                commandBar.FindControl(buttonStyle, null, tagText, null, null);

            if (aButton == null)
            {
                // Add new button
                aButton = (Office.CommandBarButton)
                    commandBar.Controls.Add(Office.MsoControlType.msoControlButton, 1, tagText, objBefore, true);

                aButton.Caption = captionText;
                aButton.Tag = tagText;
                if (buttonStyle != Office.MsoButtonStyle.msoButtonCaption)
                {
                    aButton.Picture = (IPictureDisp)AxHost2.GetIPictureDispFromPicture(picture);
                }
                aButton.Style = buttonStyle;
                aButton.TooltipText = tipText;
                aButton.BeginGroup = beginGroup;
                aButton.Click += handler;
            }

            aButton.Visible = isVisible;

            return aButton;
        }

        /// <summary>
        /// Stuff required to create XPath element
        /// (except for ID, which this method generates)
        /// </summary>
        /// <param name="xpath"></param>
        /// <param name="storeItemID"></param>
        /// <param name="prefixMappings"></param>
        /// <param name="questionID"></param>
        public static xpathsXpath updateXPathsPart(
            Office.CustomXMLPart xpathsPart,
            string xpath, 
            string xpathId,
            string storeItemID, string prefixMappings,
                                        string questionID)
        {
            //Office.CustomXMLPart xpathsPart = ((WedTaskPane)this.Parent.Parent.Parent).xpathsPart;

            xpaths xpaths = new xpaths();
            xpaths.Deserialize(xpathsPart.XML, out xpaths);

            xpathsXpath item = new xpathsXpath();
            item.id = xpathId; //System.Guid.NewGuid().ToString();

            if (!string.IsNullOrWhiteSpace(questionID))
                item.questionID = questionID;

            xpathsXpathDataBinding db = new xpathsXpathDataBinding();
            db.xpath = xpath;
            db.storeItemID = storeItemID;
            if (!string.IsNullOrWhiteSpace(prefixMappings))
                db.prefixMappings = prefixMappings;
            item.dataBinding = db;

            xpaths.xpath.Add(item);

            // Save it in docx
            string result = xpaths.Serialize();
            log.Info(result);
            CustomXmlUtilities.replaceXmlDoc(xpathsPart, result);

            return item;
        }

        public void OnButtonClick(Office.IRibbonControl control)
        {
            Microsoft.Office.Interop.Outlook.Inspector
                myInspector = Globals.ThisAddIn.Application.ActiveInspector();

            // Only works in Word
            if (myInspector.EditorType == Outlook.OlEditorType.olEditorWord)
            {
                Word.Document wd = (Word.Document)myInspector.WordEditor;

                object start = wd.Application.Selection.Range.Start;
                object end = wd.Application.Selection.Range.End;
                Word.Range rng = wd.Range(ref start, ref end);

                // Get pre designated color.
                int iColor = Convert.ToInt32(Globals.ThisAddIn.strColor);
                rng.Text = " [" + Globals.ThisAddIn.strName + " - " + System.DateTime.Now.ToString("MMM d, yyyy", CultureInfo.CreateSpecificCulture("en-US")) + "] ";

                rng.Select();
                rng.Font.Color = (Microsoft.Office.Interop.Word.WdColor)iColor;
                rng.Start = rng.End;
                rng.Select();
            }
            else
            {
                MessageBox.Show("The Signiture add-in will only work when Outlook is using the Word editor. You can change your editor under Outlook options");
            }
        }

 public string GetDescription(Office.IRibbonControl control)
 {
     switch (control.Id)
     {
         case "spaceAvailable":
         case "spaceAvailableEx":
             return Resources.description_available_storage;
         case "toggleDynamic":
         case "toggleDynamicEx":
             return  Resources.description_dynamic_content;
         case "toggleEncrypted":
         case "toggleEncryptedEx":
             return  Resources.description_encrypted;
         case "toggleAllowForwarding":
         case "toggleAllowForwardingEx":
             return Resources.description_allow_forwarding;
         case "toggleNoPlaceholder":
         case "toggleNoPlaceholderEx":
             return Resources.description_no_placeholder;
         case "buttonEditContent":
             return  Resources.description_edit_content;
         case "buttonDeleteContent":
             return Resources.description_delete_content;
         case "buttonChiaraMailAccount":
         case "groupChiaraAccount":
             return  Resources.tooltip_config_button;
         case "taskChiaraMailHelp":
             return  Resources.description_help;
         case "taskChiaraMailSupport":
             return Resources.description_support;
     }
     return "";
 }

 public void OnToggleButton1(Office.IRibbonControl control, bool isPressed)
 {
     if (isPressed)
         MessageBox.Show("Pressed");
     else
         MessageBox.Show("Released");
 }

 /// <summary>
 /// Called when SplitButton or it's submenus are clicked.
 /// </summary>
 /// <param name="control"></param>
 public void OnHighlightAction(Office.IRibbonControl control)
 {
     if (!string.IsNullOrEmpty(control.Tag))
         _defaultLang = ColorCode.Languages.FindById(control.Tag);
     _host.Highlight(new Parser(_defaultLang));
     this.ribbon.Invalidate();
 }

        public void AddAudioClick(Office.IRibbonControl control)
        {
            var currentSlide = PowerPointCurrentPresentationInfo.CurrentSlide;

            if (PowerPointCurrentPresentationInfo.SelectedSlides.Any(slide => slide.NotesPageText.Trim() != ""))
            {
                RemoveAudioEnabled = true;
                RefreshRibbonControl("RemoveAudioButton");
            }

            var allAudioFiles = NotesToAudio.EmbedSelectedSlideNotes();

            var recorderPane = Globals.ThisAddIn.GetActivePane(typeof(RecorderTaskPane));

            if (recorderPane == null) return;

            var recorder = recorderPane.Control as RecorderTaskPane;

            if (recorder == null) return;

            // initialize selected slides' audio
            recorder.InitializeAudioAndScript(PowerPointCurrentPresentationInfo.SelectedSlides.ToList(),
                                                  allAudioFiles, true);

            // if current list is visible, update the pane immediately
            if (recorderPane.Visible)
            {
                recorder.UpdateLists(currentSlide.ID);
            }

            PreviewAnimationsIfChecked();
        }

 /// <summary>
 /// Recursively construct the node's XPath, something like 
 ///   /answers/repeat[@qref='rpt1']/row[1]/answer[@id='qa_1']
 /// </summary>
 /// <param name="node"></param>
 /// <returns></returns>
 public static string getXPath(Office.CustomXMLNode node)
 {
     if (node.BaseName.Equals("answers"))
     {
         return "/oda:answers";
     }
     else if (node.BaseName.Equals("answer"))
     {
         return getXPath(node.ParentNode) + "/oda:answer[@id='"
             + CustomXMLNodeHelper.getAttribute(node, "id") + "']";
     }
     else if (node.BaseName.Equals("row"))
     {
         return getXPath(node.ParentNode) + "/oda:row[1]";
     }
     else if (node.BaseName.Equals("repeat"))
     {
         return getXPath(node.ParentNode) + "/oda:repeat[@qref='"
             + CustomXMLNodeHelper.getAttribute(node, "qref") + "']";
     }
     else if (node.NamespaceURI.Equals("http://opendope.org/answers"))
     {
         return getXPath(node.ParentNode) + "/oda:" + node.BaseName + "[1]";
     }
     else
     {
         return getXPath(node.ParentNode) + "/" + node.BaseName + "[1]";
     }
 }

 public void DisplayPresentation(Office.IRibbonControl control, bool pressed)
 {
     if (ThisAddIn.instance.customPresenterIsEnabled)
         ThisAddIn.instance.customPresenterIsEnabled = false;
     else
         ThisAddIn.instance.customPresenterIsEnabled = true;
 }

        public IEnumerable<Office.CommandBarControl> OnMailItemContextMenu(Office.CommandBar CommandBar,Office.CommandBarPopup agileCommand, IEnumerable<Outlook.MailItem> selectedMailItems)
        {
            var taggerMenuItem=(Office.CommandBarButton)agileCommand.Controls.Add(Office.MsoControlType.msoControlButton, Type.Missing, Type.Missing, Type.Missing, true);

            taggerMenuItem.Caption = "Tag";
            taggerMenuItem.Click += new Office._CommandBarButtonEvents_ClickEventHandler(taggerMenuItem_Click);
            return new List<Office.CommandBarControl>() { taggerMenuItem };
        }

 private void CopyToClipboard(Office.CommandBarButton btn, ref bool cancel)
 {
     Explorer exp = Globals.ThisAddIn.Application.ActiveExplorer();
     if (exp.Selection.Count > 0)
     {
         Clipboard.SetText(Reporting.GetMessageSource((MailItem)exp.Selection[1], false));
     }
 }