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
Get a copy of the run.vbs file.
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
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.
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
Christophe Avonture