How to execute a dynamically added or changed module
in [Programming]
|
From: NoSpam on 4 Mar 2010 14:58 I can write code to add a module to or change a module in the current project. Once this is done, how can I programmatically cause a recompile so that I can execute the new code without manual intervention? (I would like to read column headers and, depending on each header, create a variable I would use to reference that column. Then, even if columns were added or moved since the programmer wrote the code, the code would not have to change.) Thanks for any help.
From: Adrian C on 5 Mar 2010 07:24 On 04/03/2010 19:58, NoSpam(a)aol.com wrote: > I can write code to add a module to or change a module in the current > project. Once this is done, how can I programmatically cause a recompile > so that I can execute the new code without manual intervention? > > (I would like to read column headers and, depending on each header, create > a variable I would use to reference that column. Then, even if columns > were added or moved since the programmer wrote the code, the code would not > have to change.) > Not your solution to compilation, but why don't you define a 'named reference' to the column and later access it through the names collection? -- Adrian C
|
Pages: 1 Prev: create pivot chart in vbscript Next: Checking latest Forefront updates |