XVBA is a free extension for VS Code published by Local Smart (local-smart), you can install it to increase the power of your Visual Studio Code。
This is a VsCode Extension for working in VSCode whith Excel VBA files with "hotreload"
You can use Snippets, Autocomplete (Language Server), run Macros from VSCode, add namespace to your vba files etc
https://marketplace.visualstudio.com/items?itemName=local-smart.excel-live-server
Version 4.0.26
Released on 4/25/2020, 10:56:32 PM
Last updated
5/10/2022, 4:09:36 AM
Publisher Local Smart
Unique Identifier local-smart.excel-live-server
Table of Content
Download and Install Visual Studio Code for Windows: https://code.visualstudio.com/ .
Install XVBA by Local Smart
Install Chinese (Simplified) Language Pack for VS Code
step 1：down and install Visual Studio Code for Windows
https://code.visualstudio.com/sha/download?build=stable&os=win32-user
Step 2： Install XVBA for vs code
https://marketplace.visualstudio.com/items?itemName=local-smart.excel-live-server
How to use
click in the Bootstrap icon on XVBA (TreeView) ,choice "create a VBA Project"
config.json
before
{
"app_name": "XVBA",
"description": "",
"author": "",
"email": "",
"create_ate": "",
"excel_file": "index.xlsb",
"vba_folder": "vba-files",
"xvba_packages": [],
"xvba_dev_packages": [],
}Now
{
"app_name": "XVBA",
"description": "",
"author": "",
"email": "",
"create_ate": "Sun Jul 04 2021 22:50:59 GMT+0800 (中国标准时间)",
"excel_file": "ztz-SRK 冲压装箱 包装内 及成品外箱-标签18位码.xlsm",
"vba_folder": "VBACode\\Excel18",
"ribbon_file": "customUI14",
"ribbon_folder": "ribbons",
"logs": "on",
"xvba_packages": {},
"xvba_dev_packages": {}
}
Step 2：Install Chinese (Simplified) Language Pack for VS Code
https://marketplace.visualstudio.com/items?itemName=MS-CEINTL.vscode-language-pack-zh-hans
You can override the default UI language by explicitly setting the VS Code display language using the Configure Display Language command.
Press Ctrl+Shift+P to bring up the Command Palette then start typing display to filter and display the Configure Display Language command.
Press Enter and a list of installed languages by locale is displayed, with the current locale highlighted. Select another locale to switch UI language.