Excel - List all references

Retrieve the list of references used in an Excel file (.xlam files f.i.) and display them on the console. Loop and process all Excel files in the current folder

Table of Contents

• Install
• Usage
• How it works?
• Output
• Author
• License

Install

Get a copy of the run.vbs file.

Usage

Copy the run.vbs file in a folder where you've .xlam or .xlsm file and run it.

To run the script from the command line, just start a command prompt (click start then run and type CMD). Once on the command prompt, type the following instruction and press Enter:

cscript run.vbs

How it works?

The run.vbs script will retrieve all .xlam or .xlsm files in the current folder and, by automation, will start Excel for retrieving the list of addin's used by the file.

Output

Here a sample of the output generated by this script:

Processing files in C:\Christophe

Get the list of references used in C:\Christophe\Application.xlsm

    Name My_AddIn
    Full Path: C:\Christophe\My_Addin\My_AddIn.xlam

    Name A_Second_AddIn
    Full Path: C:\Christophe\A_Second_AddIn\A_Second_AddIn.xlam

Get the list of references used in C:\Christophe\Invoices.xlam

    Name My_AddIn
    Full Path: C:\Christophe\My_Addin\My_AddIn.xlam

Author

Christophe Avonture

License

MIT