Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.run for returning arrays
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA arrays | Excel Discussion (Misc queries) | |||
Arrays | Excel Discussion (Misc queries) | |||
macro to close excel application other than application.quit | Excel Programming | |||
help with arrays | Excel Programming | |||
application.quit will not shut off application | Excel Programming |