vba inspect

VBA-Inspect

VBA-Inspect is a tool for extracting VBA code present mainly in Excel files, with the ultimate objective of quickly providing an overview of the code present in these files and starting the hunt for Shadow-IT ("wild" extractions , CRUD operations via OLEDB/ODBC connections, ...).

To start

To inspect resources, we will use Python scripts.

Prerequisites

What is required to get started with your project...

• Python

Facility

Steps to use scripts....

1. Install Python on your machine
2. Clone the VBA-Inspect repository
3. Install OleTools

pip install -U oletools

4. Configure analysis using the vba-inspect.ini file

Startup

The analysis configuration is done in the /config/vba-inspect.ini file, in the DEFAULT section. You will indicate the folder to analyze and the type of file to take into account (*, *.xls, *.xlsx).

To carry out an audit, you will need to run the vba-inspect.py script

Python vba-inspect.py

The script will expose the VBA content of each analyzed file in the /out/result.log folder. The analysis logs are available in the /log/vba-inspect.log folder.

Made with

• Python - Programming language
• OleTools - Tools developed in Python to analyze OLE files and Microsoft Office files

Contributing

If you want to contribute, read the CONTRIBUTING.md file to learn how to do so.