RTD initialization

[stu]

I have had success creating an RTD server which listens to a port and
passes data to a spreadsheet. I have not been able to figure out
other than hard coding it how to pass the address and port to the
server on startup of the add-in. Any ideas? In my normal programming
I use INI files or the like.

[Govert van Drimmelen]

Hi Stuart,

You could use a standard .NET .config file.

1. Make a file called <TheAddInName>.xll.config with this in:
<configuration>
<appSettings>
<add key = "Test" value="Forty-two" />
</appSettings>
</configuration>

2. In your project, add a reference to the System.Configuration
assembly.
3. In your server add some function to access the settings:

internal static string GetAppSetting(string key)
{
object setting =
System.Configuration.ConfigurationManager.AppSettings[key];
if (setting == null)
{
return "!! INVALID KEY !!";
}
return setting.ToString();
}

-Govert

[stu]

Worked like a charm. Sometime the vastness of .NET amazes me.

Thank you

Stuart