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",???????????)