[AccessD] Excel addin syntax problem

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon May 9 17:02:25 CDT 2005


The last line here generates an error of compile error expected =. What
am I doing wrong. Thanks.

 

Set Obj = CreateObject("Excel.Application")

Obj.Workbooks.Open (Obj.Application.LibraryPath & "\SOLVER\solver.xla")

Obj.Workbooks("solver.xla").RunAutoMacros (xlAutoOpen)

Obj.Application.Run("solver.xla!SolverOk", SetCell:=Range("A1"))




More information about the AccessD mailing list