How do I add a "reference" to the Solidworks API, in MS Visual Studio 2010?

Hi to the Solidworks API community. Please forgive the elementary nature of this question, as I am a E.E. by profession, not a software or Solidworks expert.

I would like to be able to run a C# program that modifies an Excel spreadsheet, specifically, a Solidworks Design Table.I suppose that for the Solidworks "manipulation" part of the program, I could add a Visual Basic module, with MS Visual Studio.

My main question is how do I "link" (or reference, if that is the correct term) the program in Visual Studio 2010, running external to Solidworks, to Solidworks, so that I may run API calls?

Much of the documentation that I have read concerning the Solidworks API deals with running macros from within Solidworks not running external programs that modify Solidworks objects, such as a design table.

I would greatly appreciate suggestions

Thank You

Tom


SolidworksApi macros