Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon May 9 13:10:45 CDT 2005
I need to run the solver add-in in Excel from Access. I have some code
but how do I pass values to the function and then bring them back to
access? Below is what I have so far.
Dim Obj As Excel.Application
Set Obj = CreateObject("Excel.Application")
Obj.Workbooks.Open (Obj.Application.LibraryPath & "\SOLVER\solver.xla")
Then something like this?
Obj.Application.Run("solver.xla",???????????)