Headache Producing Question Here. Please help anyway!

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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hi Tom

If I have followed you correctly (not sure I have) could you simply create a link to this cell on the same sheet and then use the Calculate Event. For example if the cell that is having the data dropped in is A1, in cell Z1 put =A1 this will cause the Calculate Event to fire.
 
Upvote 0
Hi Dave!
Thanks for the reply.
You did follow me correctly, to a point.

The calculation event does indeed fire if the value fed via DDE is different from the value which is currently in the cell.

The calculation event does not seem to fire if there is no calculation. I'm overwhelmed with my brilliance> HA HA

Problem = this:

If a DDE link does not fire off a change event and the value of volume is the same as the previous transaction. I am stuck???

Time Price Volume
01:13 5420.5 40
01:15 5420.5 40

These are two different transactions.
These are actually two separate volumes.
They just happen to contain the same value.
If the same value = no calculation fired...
...and DDE does not fire the change event, how do I trap the second value?

?????????HEADACHE????????????

Cerebral Circular Reference!!!!!

And I'm doing this for free.
I deserve a headache!
Thanks for any help!
Tom
 
Upvote 0
Hi Tom

RE: If a DDE link does not fire off a change event and the value of volume is the same as the previous transaction. I am stuck???

Why can't you use the method I suggested, as this WILL fire the Calculation Event, If the value is the same or not.
 
Upvote 0
Hi Dave
That is the method I am using =A1 ect...
I placed a break in the calculation event and no code was run when the value was replaced with the same value?
Thanks
Tom
 
Upvote 0
Sorry Tom, I should have tested that first. The way around this could be to reference it via a Volatile function, eg:
=OFFSET(A1,1,1)
 
Upvote 0
Thanks Dave.
I'll give it a try.
Volatile Function?
Will educate myself on this one.
Thanks!
Tom
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top