Programming for Development of Available Information Sheets
Bin Ni · Computer Knowledge and Technology · 2008
Excel is a powerful,advanced and convenient system for data management and analysis among the OFFICE family.Program-ming the available Excel sheets with VBA(Visual Basic for Application) macro can help users generate new sheets efficiently,which can re-alize office automation.This paper uses the example of generating make-up examination entry forms from report sheets.VBA’s second exploitation in Excel has the powerful function of improving the work efficiency and guarantee the data accuracy.