Use an Excel add-in in a VB application?

[cthaxter]

I'm trying to utilize the Solver add-in from Excel, within a standard EXE.

I can't get the Solver code to compile. If I were in VBA in Excel, I might have

solverreset
solverok SetCell:="$C$6", MaxMinVal:=3, ValueOf:="180", _
ByChange:="$C$4:$C$5"
solversolve

and, with the Solver added in and the reference to the Solver added in, this code works marvelously.

However, I can't figure out how to do the same thing in a Visual Basic standard exe project. Any help would be MUCH appreciated.

Thanks,

Christopher