The paper analyzed the present situations of calcuating weir head in the ponds comprehensive improvement project.Aiming at the existing problems,it proposed the application of the secondary development tools of Excel VBA to weir head calculation.Automatic calculation was implemented for the weir head in the comprehensive improvement project through writing the calculating programs and using the visual window as operating interface.This program can be applied in the ponds practice,the results showed that the...