L
levent
hi
with regard to accessing excel functions from VBA,
i have learned (at this forum) that you can do the
following:
a = Application.Run("ATPVBAEN.XLA!IMPRODUCT", A, b)
(when the excel function returns a single value)
however, when i try to do this for an excel function that
returns an ARRAY, it does not work. (there is an add-in
that does matrix operations e.g. matrix inversion, so both
inputs and output is a two-dimensional array)
is there a way to do this without having to dump things
into excel and input from excel again?
with regard to accessing excel functions from VBA,
i have learned (at this forum) that you can do the
following:
a = Application.Run("ATPVBAEN.XLA!IMPRODUCT", A, b)
(when the excel function returns a single value)
however, when i try to do this for an excel function that
returns an ARRAY, it does not work. (there is an add-in
that does matrix operations e.g. matrix inversion, so both
inputs and output is a two-dimensional array)
is there a way to do this without having to dump things
into excel and input from excel again?