Can Excel VBA make calls to functions in dlls? How about dot-net dlls? RRS feed

  • Question

  • Can I make a dot net dll in visual studio (using visual basic) and have Excel call its methods?
    I would like to create a dll using visual basic dot net, and then call its methods/functions from Excel's VBA. That way, Excel can pass data to my dll, and obtain a vector of answers. Can this be done? 

    If not a dot-net dll, than how about a regular dll?


    Sunday, September 20, 2020 1:44 PM