1. Very simple question is so long I write, I really admire his *^_^* 2. On the domino thing that comes with the html view source, it may be helpful to solve the problem. , Instead of using For loop Do loop Do loop will be repeated because the calculation of condition! 2, in the number of group elements in the circular instead of using Forall for. Dollar 75% of the array will be faster, dual will be faster about 50%. 3, simplifying If in the conditions, such as: if a = x and b = y not if a = x then if b = y quickly, should the second condition for the latter condition is true in only the first calculated . 4, instead of using Search and FTSearch method GetView method. 5, try to avoid mixing data types are calculated, for example, avoid using single + long this will reduce the rate of 40%. 6, with doc.ColumnValues property values than other faster access to the document. 7, in the division, use "" instead of "/", use "/" are floating point, with the "" be an integer. 8, avoid the use of Variant types of data, because the Variant type, and contains too much data. 9, to avoid excessive use of the array, removing unnecessary array.
According to the U.S. "CFO" magazine, in 1999, about 39% of the newly appointed CEO CFO was fired, 75% of the CEO fired the current CFO - CFO One of the important reasons is to develop corporate strategy must one of the participants, if he and the CEO of the disagreement, only clean bedding leave. Budget for each fiscal year, Microsoft plans to be detailed and thorough combing, and other multinational corporations as well. Financial planning business operations and market development for the extreme importance is obvious. In sharp contrast, is the CFO of many enterprises on the budget and planning inactivity on the pretext that the industry is developing too fast, always keep up with changes planned, so enterprise budget is optional. Some analysis of a variety of reasons: "This is because they do plan, the middle step does not do a lot worse, only to seize a number of isolated fragments, this of course can not see the overall situation. And many of CFO when a budget and did not take into account the purpose of the enterprise, often a budget for the budget to do so would certainly not have any meaning. " When budgeting, with expected time of occurrence of a large deviation from how to do? Industry have suggested that companies should have a total monthly assessment of important indicators CFO should be read every day. At this time the role of CFO emerges timely detection bias, promptly notify the responsible person. Bias will certainly be the key lies CFOs radar system can detect if there is a solution found.