How to pass a list (returned in a VB.net function) in VBScript?

Question

I have a system function in VB.net that return a list of Strings (I've debugged this function). And right now I need to call that system function in VBScript. How can I get that list of strings?

VB.net system function

Public Function someList As List(Of String)
    Return List
End Function

VBScript:

Dim results
Set results = System.someList

For Each result In results
    wscript.echo result
Next

Hi, thanks for your reply. I have some system functions that need to be called by the vbscript file. And all the others functions can be called successful. Only this function returns a List that couldn't be called. So I think the return type of this function might cause the problem. I wonder can I still use List as the return type? Or I need to change the return type to ArrayList? Or do you have any suggestions for me? — Naomi Wu
– Naomi Wu, Commented Jan 20, 2019 at 22:10
VBScript cannot use .Net APIs unless the .Net class exposes a COM interface (like ArrayList or StringBuilder). — Ansgar Wiechers
– Ansgar Wiechers, Commented Jan 20, 2019 at 22:12
Also, all the other functions are called by the function name. I use something like this: wscript.echo System.FunctionName. And when I run the file it gives me the correct value in the popup window — Naomi Wu
– Naomi Wu, Commented Jan 20, 2019 at 22:12
WScript is an intrinsic object provided by the runtime environment (more specifically by the interpreters wscript.exe and cscript.exe). The same does not apply to the .Net System namespace. — Ansgar Wiechers
– Ansgar Wiechers, Commented Jan 20, 2019 at 22:31

Geert Bellekens · Accepted Answer · 2019-01-21 08:44:52Z

1

The problem is that VBScript doesn't understand Generic classes (or is it COM that is the problem?), so you'll have to convert your list to something non-generic such as ArrayList.

I had the same problem when trying to use my C# library from VBScript and I wrote a simple conversion function (in C#) to overcome this problem:

    public ArrayList toArrayList(IEnumerable collection)
    {
        var arrayList = new ArrayList();
        foreach (object element in collection)
        {
            arrayList.Add(element);
        }
        return arrayList;
    }

Some more helper functions I needed to get things working can be found here: ScriptingInteropHelper

answered Jan 21, 2019 at 8:44

Geert Bellekens

13.9k3 gold badges31 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass a list (returned in a VB.net function) in VBScript?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related