Popular blog tags

Excel VBA:Using Visual Studio Code with Xvba Tools Instead of Built in VBA IDE Editor

Published

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.

 

 

 

 

 

工具推荐:用VS code 导出、导入和运行Excel中的VBA代码

让vsCode支持gbk/gk2312,解决vsCode中文乱码,搜索列表乱码