I'm trying to use Webservice with Excel DNA. As of now I'm adding the web-reference maually, but i want to configure my application on environment base so that it can pick Web Reference URL dynamically for PROD,UAT,QA.
Is there any way by which we can define config file for ExcelDNA Application and pick the values from there.
Also, What's the start point for ExcelDNA application. Is there any way by which we can define Main() function & intialize some variables.
Can we set default class or define Constructor in any class?
I know, in .dna file we can define External Library Path as below
But still want to know start point of an application.