Replaying data with Lookout

[Jim Z]

I'm trying to use Lookout to continuously replay some data I grabbed with the spreadsheet object. Lookout will serve as a MODBUS slave for a touch panel display. I've tried using an Excel macro and getting the data to Lookout via DDE. I can make the DDE link work and I can make the Excel macro work. But when I combine them the Excel macro takes over the computer and allows nothing else to happen including the DDE link. Any suggestions would be appreciated.
Jim Z.
zurlo@execpc.com

[mrak1]

Hi Jim,

It seems like Excel is behaving badly. Have you considered passing the files through a .txt file? This would make the situation more complicated. Here would be the steps:

-write the file of data
-open it in Excel
-execute the macro
-reopen it in Lookout

This may be difficult to implement but it is a suggestion.

Another suggestion would be to use Lookout's Citadel Database to log the data and then use MSQuery in Excel to grab the data. I am not certain if this will fit your application. You can find information about using MSQuery with Lookout here:
Accessing Citadel Data with Microsoft Excel

Regards,
Mike