Abstract: In the investigation of geotechnical engineering, according to criterion, we need evaluate the corrosiveness of water and soil in foundation depth. If the area of site is large, water and soil samples will be a big number due to evaluation including many factors, if all work is done by hand, workload will be heavy. Because the test results is in MS Excel type, the VBA method can be fast and accurate to evaluate corrosiveness of water and soil, and thus provide better services for investigation report.