how to invoke my VB.net form from a COM application?

12 May 2006 6:07 PM

mrmagoo

How do I make my VB.Net form callable from an Excel application? It's a
utility independent from Excel, but I want to be able to call it from Excel.
I know a lot about VBA but don't know how to get a handle on the .net form
and make it visible.

thx

12 May 2006 7:50 PM

aaron.kempf@gmail.com

uh dont you need visual studio tools for office?

i've been to a couple of users' group meetings and i've seen some
pretty snazzy stuff out of vsto

-aaron

13 May 2006 7:19 AM

mrmagoo

No. I'm talking about a .Net solutions, and all that is needed from the COM
side of things is to "show" the .Net form. To do that, some things have to
be added to the .Net solution.

I know one approach is using ComClass. I'm hoping to get step by step
instructions or find out other ways, if there are.

Anyway I'm looking around for articles that go into more detail.

<aaron.ke***@gmail.com> wrote in message
Show quoteHide quote

news:1147463438.352134.310310@i39g2000cwa.googlegroups.com...
> uh dont you need visual studio tools for office?
>
> i've been to a couple of users' group meetings and i've seen some
> pretty snazzy stuff out of vsto
>
> -aaron
>

12 May 2006 8:07 PM

Jeff Dillon

Shell to the exe?

Show quoteHide quote

"mrmagoo" <-> wrote in message news:OkGbt6edGHA.4148@TK2MSFTNGP05.phx.gbl...
> How do I make my VB.Net form callable from an Excel application? It's a
> utility independent from Excel, but I want to be able to call it from
> Excel.
> I know a lot about VBA but don't know how to get a handle on the .net form
> and make it visible.
>
> thx
>
>