Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question