

This approach lets you export several projects simultaneously. VBA Plug will retrieve all open VBA projects. Switch to VBA Plug and let it connect to Office. Run an Office application and open the required documents in it. If it fails-due to security options, for example-try approach B.ī. Unfortunately, the A approach doesn't always work.


Leave it unselected to export just one VBA project, the one in the file you opened. Select this checkbox to export all projects referenced by the selected Office file. VBA Plug opens it in Office and retrieves the VBA code in it. You run the program by clicking the file vbaplug.exe.Īfter starting VBA Plug, you have 2 alternatives to retrieving your VBA code.Ī. It does not install itself inside the VBA environment or as an Office menu item. VBA Plug will retrieve the VBA source, save it in a new directory and run Project Analyzer on it. Alternatively, open the file in Office and select "Connect to running application". In the "Read Office file" field, enter the Office file you wish to analyze.
