Pass Value from exe to macro and vice versa

[vbshuru]

Can someone please help me?

I need to pass a count from macro to the executable and I have no idea how to do that.

I have to run this executable multiple times a day. The executable kicks off the macro. I want to pass the count from macro to executable.

i read somewhere that you can pass data from macro to exec. by using Return() function. but I have no idea how to use this. I couldn't find any online help with regards to this.

Also is there any way to tally the total count, from all the runs through out the day?



Any ideas, suggestions, comments, code samples will be appreciated.

Thanks!

[yrwyddfa]

Two ways I can immediately think of . . .

(i) SendMessage

(ii) if the macro shells the executable set the exe up to read the command line and take the value from there

[vbshuru]

How do I pass data from the macro to the exec?

[yrwyddfa]

use WM_COPYDATA message. Serialise your data into a property bag, create a byte array from property bag, and then pass a pointer to the array

[vbshuru]

Thank you yrwyddfa