An Automatic Transformation Technical Solution for Behavior Control Scripting Languages

This paper proposed an automatic transformation technical solution for behavior control scripting languages. The solution automatically converts VBA scripting language into JavaScript scripting language. It implements automatic transformation by analyzing and comparing differences in the use of different grammatical of VBA scripts and JavaScript scripts such as data types, control structures, form controls and add-ins Etc. To ensure the accuracy and completeness of conversion the solution generates an abstract syntax tree which represents call and transitive relation between functions. Compared with the conversion tools the solution can reduce repeated manpower and improve productivity.