Prev: Disable loading of images in WebBrowser control
Next: Reading from LDAP searchresults
From: Lucio Menci on 10 Jun 2010 05:08
Hi all,

I have .Net 2005 Pro.
I want to create a VB application where I can manage Excel.
From Excel I want to launch that application, this application have to
start, recognize witch instance of Excel was the launcher and write something
into some cells.

Sometimes I noted that I have more than one instances of running Excel.
If I use GetObject I cannot choose witch instance of Excel I have to manage.
If I create a DLL (exposed or not via COM), I cannot include that library in
a Excel macro (why? Or, better, How can I create a library includable into
Excel?)

There is another way to access to an external program except the GetObject
function?
From: Robert Ellis on 10 Jun 2010 18:24

You will probably have to look at one or more Win32 API calls if you want to
do exactly as you propose.

It is not fun. Especially from VB.


"Lucio Menci" <LucioMenci(a)discussions.microsoft.com> wrote in message
news:03D4B3E2-BC58-49A2-AD27-9C76613BD244(a)microsoft.com...
> Hi all,
>
> I have .Net 2005 Pro.
> I want to create a VB application where I can manage Excel.
> From Excel I want to launch that application, this application have to
> start, recognize witch instance of Excel was the launcher and write
> something
> into some cells.
>
> Sometimes I noted that I have more than one instances of running Excel.
> If I use GetObject I cannot choose witch instance of Excel I have to
> manage.
> If I create a DLL (exposed or not via COM), I cannot include that library
> in
> a Excel macro (why? Or, better, How can I create a library includable into
> Excel?)
>
> There is another way to access to an external program except the GetObject
> function?


From: Lucio Menci on 14 Jun 2010 03:53
Uhm...
Do you know some API calls that supply a COM access? I cannot find anyone...

And the way to include a VB2005 library into a VBA project of Excel?

"Robert Ellis" wrote:

>
> You will probably have to look at one or more Win32 API calls if you want to
> do exactly as you propose.
>
> It is not fun. Especially from VB.
>
>
> "Lucio Menci" <LucioMenci(a)discussions.microsoft.com> wrote in message
> news:03D4B3E2-BC58-49A2-AD27-9C76613BD244(a)microsoft.com...
> > Hi all,
> >
> > I have .Net 2005 Pro.
> > I want to create a VB application where I can manage Excel.
> > From Excel I want to launch that application, this application have to
> > start, recognize witch instance of Excel was the launcher and write
> > something
> > into some cells.
> >
> > Sometimes I noted that I have more than one instances of running Excel.
> > If I use GetObject I cannot choose witch instance of Excel I have to
> > manage.
> > If I create a DLL (exposed or not via COM), I cannot include that library
> > in
> > a Excel macro (why? Or, better, How can I create a library includable into
> > Excel?)
> >
> > There is another way to access to an external program except the GetObject
> > function?
>
>
> .
>
 | 
Pages: 1
Prev: Disable loading of images in WebBrowser control
Next: Reading from LDAP searchresults