LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.dotnet.general,microsoft.public.dotnet.framework.remoting,microsoft.public.dotnet.framework.windowsforms,microsoft.public.dotnet.framework.interop,microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default What is the simplest IPC from Excel VBA to a .NET app?

What is the simplest way for VBA code (in Excel) to send some sort
of signal to a .NET process and tell it to do something? The VBA
code knows the task ID of the .NET process, because it started that
process (a Windows Forms app) using Shell(). It isn't necessary
to pass any information either way (although that wouldn't hurt);
all that is needed is a way to poke at the .NET process so that it
wakes up and looks for an instruction file that has just been
written by Excel.

Right now the .NET process is polling the disk, looking for new
instruction files. This actually works fine, but since there can
be long intervals between new instruction files, it would be better
if there were some way for Excel to notify the .NET process directly
when a new file is written. I'm sure there's a way to do this
using sockets and threads, but I'd like to add as little complexity
as possible, so if anyone knows a simpler way I hope you will let
me know about it.
--
John Brock


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 very slow to open even the simplest worksheet John Excel Discussion (Misc queries) 25 July 10th 13 05:24 AM
Simplest Question James8309 Charts and Charting in Excel 2 July 21st 08 12:02 AM
What is the simplest way to do addtion of cells on reports. Elaine Excel Discussion (Misc queries) 1 April 17th 07 12:58 AM
What is the simplest way famdamly Excel Discussion (Misc queries) 4 February 16th 06 10:23 PM
What is the simplest way to print multiple worksheets? substring Charts and Charting in Excel 1 April 21st 05 11:49 PM


All times are GMT +1. The time now is 09:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"