ExcelBanter - View Single Post - How to execute a dynamically added or changed module

Adrian C[_2_]

On 04/03/2010 19:58, 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