Rod
King
Hi,
yesterday I tried my hands firsttime one the Visual Basic of Excel 2007 in the FFH-Editor. The reason is that I want to edit the script 14 for Diplomacy screen.
I am adding 6 leaders for a personal scenario and even when you can easily do the same in the most sheets the Diplomacy screen is giving a problem.
I explain it briefly. The most table sheets are counting columns (every column has a '1' written in one row). Therefore you can easily add new columns because they get counted as well.
But the diplomacy table sheet is working different. It still using columns and counts them, but the the leaders are listed in rows (rows do not get counted).
Therefore the script is hardcoded on terms of rows (but uses variables for the columns). So far so easy.
The easy way out to add 6 leaders is simply to change the rows in the script (simply add 6 to all entries).
I show what I mean :
you get the idea.
The other way is to add a row counter in Cell B4 (Cells(4,2)) :
I have not tested this last script, it was just an idea.
But the problem is not to change the code, but as soon as I want to execute the script it gives me an error that Private Sub CommandButton1_Click() can not be compiled because it is not found in the library.
Certainly I am just missing the libraries for Excel 2007, the question is now what do I have to install/activate (whatever) in Excel 2007 to execute VBA scripts like the ones used for FFH-Editor XML-Export-scripts ???
yesterday I tried my hands firsttime one the Visual Basic of Excel 2007 in the FFH-Editor. The reason is that I want to edit the script 14 for Diplomacy screen.
I am adding 6 leaders for a personal scenario and even when you can easily do the same in the most sheets the Diplomacy screen is giving a problem.
I explain it briefly. The most table sheets are counting columns (every column has a '1' written in one row). Therefore you can easily add new columns because they get counted as well.
But the diplomacy table sheet is working different. It still using columns and counts them, but the the leaders are listed in rows (rows do not get counted).
Therefore the script is hardcoded on terms of rows (but uses variables for the columns). So far so easy.
The easy way out to add 6 leaders is simply to change the rows in the script (simply add 6 to all entries).
I show what I mean :
Spoiler :
you get the idea.
The other way is to add a row counter in Cell B4 (Cells(4,2)) :
Spoiler :
I have not tested this last script, it was just an idea.
But the problem is not to change the code, but as soon as I want to execute the script it gives me an error that Private Sub CommandButton1_Click() can not be compiled because it is not found in the library.
Certainly I am just missing the libraries for Excel 2007, the question is now what do I have to install/activate (whatever) in Excel 2007 to execute VBA scripts like the ones used for FFH-Editor XML-Export-scripts ???
