project default settings RRS feed

  • Question

  • i am creating an addin for ms excel. I created buttons similar to what i have done in ms word. But in msword i used

    this.Application.NormalTemplate.Saved = true

    But in excel i got an error while i used the same.So what should be used instead of that NormalTemplate.Saved.


    And also i have created an app.config for storing default settings.. i have created a windows form to enable the user to change the default settings after clicking the save button.

    while i am doing for word it works but for excel i did the same procedure . It is not working.The file path is displaying only when i click the fileopendialog button but after saving and close ..i can not see the file path in the text box.

    How can i check whether values in default settings have changed.

    i have given my code below:

      private void btnSave_Click(object sender, EventArgs e)

     //Saves Application Settings
            private void SaveApplicationSettings()
                Properties.Settings settings = Properties.Settings.Default;
                settings.ShowCopyConfirmation = (chkCopyConfirmation.Checked).ToString();
                settings.SourceCertificatePath = tbSourceCertificate.Text;
                settings.MasterCertificate = tbMasterCertificate.Text;


    thank you sir

    Friday, January 13, 2012 5:49 AM

All replies

  • Hi Shyamaldas

    Shouldn't this be in the Excel for Developers forum?

    Cindy Meister, VSTO/Word MVP
    Friday, January 13, 2012 7:19 AM