serkonda7/vscode-vba

Excel / VBA type library exports

sancarn opened this issue · 1 comments

sancarn commented

I've built an exporter for VBA type information.

As a result you can find all types in VBE7.dll and Excel which are both common exports for VBA usage.

It would be great if VSCode vba could use this as an upstream resource. I.E. Currently only CoClass Collection, as well as base types Integer, Long etc. are highlighted. Theoretically ErrObject should also be highlighted. Similarly with Global,Constants,Strings, ... and other Modules.

It may be worth while to have a config for including syntax highlighting of type libraries, having VBE7 by default but optionally using Excel, Access, Word, ... by user preference? These should be generatable I believe. Something like:

new Regex((await (await fetch(url)).json()).filter(e=>["Module","CoClass","Class"].indexOf(e.type)>0 && e.name.charAt(0)!="_").join("|"), "i")
serkonda7 commented

Nice suggestion. It would definitely be beneficial!

A possible implementation might use semantic highlighting.

  • 👍2