EED Non-Worksheet Functions for VBA?
I am trying to write some custom VBA to go along with our implementation of BPC's Excel Add-On. Basically I am trying to query the server for a list of vendors that I could use to then populate a listbox with. In a worksheet I would use a function like =EVEXP("Production", "All_Vendors") to have cells populated with this information. However, when I try to call this function directly in VBa using EED.g_clsExcel.evprp("Production", "All_Vendors") I get an error that an Argument is not optional, which I assume is related to the formula expecting a range for a worksheet.
So my question is, does anyone know of any function that would allow me to query the server and get an array/dictionary/collection/etc... of values that I can use in a VBA function, as opposed to having to write the values to a worksheet and read from there?