spences10/vscode-vba

VBA syntax highlighting and snippets for use in VSCode

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.

ext install vba

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:

# login
vsce login <publisher name>
# install the things
npm i
# use the token created in earlier step
vsce package
# myExtension.vsix generated
# bump version
vsce publish minor # | major | patch
# vsce publish major, minor or patch
vsce publish -p <add created token here>

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

• microsoft/vscode-vsce#11

Some good documentation on publishing with the CLI:

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