L
Legacy 98055
Guest
Hi
Ivan helped me out on this about a week ago by telling me that a DDE link may not fire off the change event.
Solution:
Link to a formula. Use the calculation event instead. Works fine!
I will try and encapsulate this as best as I am able.
Am writing a trade tracking spreadsheet which tracks changes in two values:
Price and volume
However, I do not have access to the DDE link for the fellow I am creating the spreadsheet for.
Instead I created a standalone VB program which throws random prices and volumes into the spreadsheet via Ole.
Really, my main question is this:
Does Excel respond to Ole the same way it responds to a DDE link?
My problem is repeating values
Take these two seperate transactions:
Time Price Volume
01:13 5420.5 40
01:15 5420.5 40
The program will need to accumulate the volume for the same price.
The spreadsheet would save this as:
5420.5 80
The problem is this:
The calculation event is not fired if the same value replaces that which is in the cell. However, the change event does fire. Even when replaced with the same value.
If a DDE link will not fire off the change event, how do I capture the same volume?
Any help would be greatly appreciated!
I do hate failing!
Thanks!
Tom
Ivan helped me out on this about a week ago by telling me that a DDE link may not fire off the change event.
Solution:
Link to a formula. Use the calculation event instead. Works fine!
I will try and encapsulate this as best as I am able.
Am writing a trade tracking spreadsheet which tracks changes in two values:
Price and volume
However, I do not have access to the DDE link for the fellow I am creating the spreadsheet for.
Instead I created a standalone VB program which throws random prices and volumes into the spreadsheet via Ole.
Really, my main question is this:
Does Excel respond to Ole the same way it responds to a DDE link?
My problem is repeating values
Take these two seperate transactions:
Time Price Volume
01:13 5420.5 40
01:15 5420.5 40
The program will need to accumulate the volume for the same price.
The spreadsheet would save this as:
5420.5 80
The problem is this:
The calculation event is not fired if the same value replaces that which is in the cell. However, the change event does fire. Even when replaced with the same value.
If a DDE link will not fire off the change event, how do I capture the same volume?
Any help would be greatly appreciated!
I do hate failing!
Thanks!
Tom