|
VBA Programming
This section is dedicated to various aspects of programming as related to
Microsoft Project. Typically, most programming can be accomplished with
Visual Basic for Applications. Where this is not the case, I will make
special note.
Think Big
Most people write "quick" code designed to do one task efficiently to solve a
specific problem they are having at the time. What I do, is try to think
of re-using the code I write. For example, if I need to make a calculation
of which tasks are at least 80% and set Flag2=True for each of those items, I
could easily write code to do that.
Instead, try to think bigger than the immediate problem. Why not
make a form that allows me to input any percent and then a drop down to select
any field (Flag, Text) to write the result? This way, I already have the general
problem solved and am not locked in to the Flag2 field. This way, i I have
options. For example, in the "next file" the Flag2 field may be already
used for another purpose.
Creating reusable and flexible code allows you to create your own toolbox for
use in future assignments. This will decrease the time it will take to
solve similar problems in the future.
Code Samples
I will put items up here from time to time. Keep in mind, I dont like to give
away my work.
|
|
|