VSCode VBA installs statistics

VSCode VBA

• VSCode VBA • Syntax Highlighting • Snippets • Basic code • Installation • Contributing • Contacts • Links • Handy links

Syntax Highlighting

This package provides syntax highlighting and snippets of VBA.

Based off an import of the [VBScript.tmLanguage] file from the [Sublime Text VBScript] repository.

Snippets

Basic code

• dim declarations • if/else • for/while • sub/function with errHandler • case

Installation

Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.

Contributing

Please fork this repository and contribute back using pull requests.

Any contributions, large or small, major features, bugfixes and integration tests are welcomed and appreciated but will be thoroughly reviewed and discussed.

Contacts

You can contact me in the following ways:

• Mail : [spences10apps@gmail.com] • Github : [spences10]

Links

• [Source Code] • [Market]

Handy links

I struggled to find how to generate a token after not doing anything with this project for well over a year:

To get to your token creation, go here:

• https://YOUR_USER_NAME.visualstudio.com/_details/security/tokens

Create a token:

• Name: vsce • Organisation: All accessible organizations • show all scopes, select: • Marketplace • Check Acquire and Manage

Publish with CLI:

If you get ERROR Failed request: (401) see here:

• https://github.com/Microsoft/vscode-vsce/issues/11

Some good documentation on publishing with the CLI:

• https://code.visualstudio.com/api/working-with-extensions/publishing-extension

[vbscript.tmlanguage]: https://github.com/SublimeText/VBScript/blob/master/VBScript.tmLanguage

[market]: https://marketplace.visualstudio.com/items?itemName=spences10.VBA

Description from the VS Code Marketplace listing.