/Visual Studio 2008/VBVstoExcelWorkbook/My Project/Settings.settings

<?xml version='1.0' encoding='utf-8'?>

<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="" GeneratedClassName="Settings" UseMySettingsClassName="true">

  <Profiles />

  <Settings>

    <Setting Name="SchoolConnectionString" Type="(Connection string)" Scope="Application">

      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;

&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;

  &lt;ConnectionString&gt;Data Source=v-zhaom1\SQLExpress;Initial Catalog=SQLServer2005DB;User ID=sa;Password=111111&lt;/ConnectionString&gt;

  &lt;ProviderName&gt;System.Data.SqlClient&lt;/ProviderName&gt;

&lt;/SerializableConnectionString&gt;</DesignTimeValue>

      <Value Profile="(Default)">Data Source=v-zhaom1\SQLExpress;Initial Catalog=SQLServer2005DB;User ID=sa;Password=111111</Value>

    </Setting>

  </Settings>

</SettingsFile>