[AccessD] Run Excel Solver from Access

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

 




More information about the AccessD mailing list