Abstract: In view of problems such as duplicate input, time-consuming, error-prone and so on existed in manually compiled inspection reports with format of Word, the paper proposed a compilation scheme of mine-used products inspection report based on VBA.The scheme provides user input interface through VBA program in Word document, calls relevant Excel and Word documents automatically and completes extraction and preservation of required information and writing of inspection reports. The scheme can avoid duplicate input and promote efficiency and level of office automation. The practical application result is good.