How to trigger a Visual Studio Macro from the command prompt?

Question

My requirement is quite simple. All I wish to do is copy the error list from Visual Studio and paste it in an excel sheet. But I want to do it from the command prompt. Let's assume that I have a Visual Studio macro that copies the error list. Now, how do I trigger that macro from the command prompt and paste it into the excel sheet?

or, is it possible to write a macro to copy the entire error list and paste it into an excel in visual studio macros? and further, trigger that macro from the command prompt.

Answer 1

You can execute a command in a running Visual Studio instance with the following PowerShell script:

$dte = [runtime.interopservices.marshal]::GetActiveObject("visualstudio.dte")
$dte.ExecuteCommand("Help.About")