Updating External DDE Tables Using a Manual Calculation Trigger Mechanism

Well, I have some pretty simple code here that works if I step through it manually. But if I run the subroutine the screen will not update and the job doesn't get done.
I have a workbook with 4 worksheets. On each worksheet is a table that updates to an outside DDE feed. Each table is identical and is pointing to the same feed. The only requirement for each table to work is to have it subjected to calculation.
If I set the workbook to automatic calculation, all of the tables update nicely, but my application demands that it be run in manual calculation mode. How can I modify the code so that the tables update with the new values from the DDE?
Submiting the workbook as an example would not help too much since the DDE is somewhat specfic to the user.

Please Login or Register  to view this content.

Updating will be performed by 'refresh' not by 'calculate'.

I think this might suffice:

Please Login or Register  to view this content.