View Single Post
  #5   Report Post  
Posted to microsoft.public.dotnet.general,microsoft.public.excel.misc
John Brock John Brock is offline
external usenet poster
 
Posts: 43
Default What is the simplest IPC from Excel VBA to a .NET app?

In article , Jamesb wrote:

I can get around this of course by writing the file under a different
name and then renaming it. I'm still hoping though to find some
easy way to use the task ID to directly signal the .NET process
from Excel, or even pass it a string. But if I can't then
FileSystemWatcher it is.


If your .NET process has a window then you can use FindWindow to find
the window handle then SendMessage to send it a message. These are
Win32 API functions, but you should be able to call them from VBA with
suitable declarations.

http://msdn.microsoft.com/en-us/libr...50(VS.85).aspx

http://msdn.microsoft.com/en-us/libr...99(VS.85).aspx

http://msdn.microsoft.com/en-us/libr...31(VS.85).aspx


Thanks. Looks interesting, but possibly overcomplicated for what
I'm doing.

Do you know what the .NET process needs to do to receive messages?
The process does have a window, but I'm not finding much information
about using SendWindow with .NET.
--
John Brock