vba engine, written in typescript/javascript

何一鸣

·

Follow

1 min read

·

Dec 8, 2021

--

Listen

Share

demo

npm package

features

• basic type: integer, array, string, double, date
• expression: not > < <> = >= <= + & * / \ ^ += -= xor and or
• visibility: public/private variable and sub/function
• control logic: with, if then else, do while, for next, for each, goto
• function: sub/function, static variable
• error handling: function top level error handling
• class module
• binding: sub binding and class binding, vba engine even sub binding to provide native vba function/class, such as lbound/ubound/Collection

usage

import { Context, SubBinding } from 'vba';const sampleCode = `
sub main
debug.print 1
debug.print 2
end sub
`.trim();const MsgBoxSub: SubBinding = {
  name: 'debug.print',
  argumentsInfo: [
    {
      name: 'msg',
    },
  ],
  async value(args) {
    console.log((await args.getValue('msg'))?.value);
  },
};async function main(){
  const context = new Context();
  context.registerSubBinding(MsgBoxSub);
  await context.load(sampleCode);
  await context.callSub('main');
  // console log 1 and 2
}main();

codesandbox