How do I call .NET code (C#/vb.net) from vbScript?

问题:

I imagine I can compile a C# DLL and then expose it as a COM object so that it can be CreateObject'd from VBscript. I'm just not sure the steps involved in doing this...

回答1:

It can be very simple to do this. But there are a lot of places where it's not so simple. It depends a lot on what your class needs to be able to do, and how you intend to deploy it.

Some issues to consider:

• Your class has to have a parameterless constructor.
• It can't expose static methods.
• Is deploying your COM DLL in the global assembly cache OK? If not, you're going to have to give it a strong name and register it using regasm /codebase.
• Do you care what GUIDs identify the class and its interfaces? If not, you can let regasm assign them, but they'll be different every time (and every place) the class is registered. If you need the GUIDs to remain invariant across installations, you'll need to mark members with the Guid attribute.
• Are you going to use the default marshaling of data types between .NET and COM? If not, you're going to need to mark properties and methods with the MarshalAs attribute.
• Does it matter to you what kind of COM interface your class exposes? If so, you're going to need to deal with the InterfaceType attribute.
• Does your class need to raise or respond to events? If so, there are implications for how you design your class interface.

There's a very good (if dated) article about COM interop and .Net here. (A lot of things that article talks about, like generating type libraries, is handled for you automatically now.) And Microsoft's documentation is up to date, but not quite so detailed.

回答2:

You should use the regasm utility to register an assembly (just like you do regsvr32 with COM servers). Then you can use it from COM. Make sure it's installed in the GAC. The stuff should have [ComVisible(true)] to be usable from COM.

回答3:

There's a "COM Accessible" option for each project you can select. Then, of course, you have to register the assembly to use it, but that's about it.

---

I had to go hunting a bit to find it for C# (I'm used to VB.Net), but you can find the option by double-clicking on the Properties folder in the Solution Explorer, choosing the Application tab and then clicking the Assembly Information... button.