ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to execute a dynamically added or changed module (https://www.excelbanter.com/excel-programming/440244-how-execute-dynamically-added-changed-module.html)

[email protected]

How to execute a dynamically added or changed module
 
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.

Adrian C[_2_]

How to execute a dynamically added or changed module
 
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


All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com