Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: Matrix Multiplication in MS Access VBA

    Is there an easy way to invoke the excel mmult or minverse functions from MS Access VBA?

    Alternatively, is there an easy way to use, package, and distribute a matrix dll library (I have never done this before).


  2. #2
    Join Date
    Apr 2004
    outside the rim
    For the first question, "yes, there is".

    The implied followup question is "How?" and here's the answer:

    First, reference Microsoft Excel in Access VBA, then use an Excel object to utilize any function, procedure and object the Excel has to offer.

    Dim objExcel As Excel.Application
    Set objExcel = GetObject(, "Excel.Application")

    ... some code ...

    Set objExcel = Nothing

    HERE is more information.

    Have fun,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts