T
teddysnips
SCENARIO
A factory production line uses RSLINX software to gather data from PCI
cards and expose it through DDE.
An Excel spreadsheet consumes this via Copy and Paste of the link from
RSLINX.
This spreadsheet is then saved in XML format.
This XML file is in turn consumed by a web page that displays the data
gathered by the RSLINX software. The web page is set to refresh at 30s
intervals.
PROBLEM
The Excel spreadsheet is updated in real time (you can see the numbers
change as the data is pumped in by RSLINX), but of course the XML file
is not updated until the file is saved, so the data on the web page is
not updated unless and until the spreadsheet is saved.
The client obtained a cheap "autosave" Excel plug-in to save the
spreadsheet periodically, but it doesn't work reliably.
DESIRED SOLUTION
Remove the Excel middleware and replace it with an applet that will
consume the DDE data directly and transform it into the XML file
required by the web page. I was thinking of a windows service or
something similar. They don't want a console application/scheduled
task solution. The budget is TINY.
ACCEPTABLE SOLUTION
A reliable means of saving the XML file periodically. The most
important word in that sentence is "reliable". A background timer in a
macro? A save triggered by a cell's Change event firing?
A factory production line uses RSLINX software to gather data from PCI
cards and expose it through DDE.
An Excel spreadsheet consumes this via Copy and Paste of the link from
RSLINX.
This spreadsheet is then saved in XML format.
This XML file is in turn consumed by a web page that displays the data
gathered by the RSLINX software. The web page is set to refresh at 30s
intervals.
PROBLEM
The Excel spreadsheet is updated in real time (you can see the numbers
change as the data is pumped in by RSLINX), but of course the XML file
is not updated until the file is saved, so the data on the web page is
not updated unless and until the spreadsheet is saved.
The client obtained a cheap "autosave" Excel plug-in to save the
spreadsheet periodically, but it doesn't work reliably.
DESIRED SOLUTION
Remove the Excel middleware and replace it with an applet that will
consume the DDE data directly and transform it into the XML file
required by the web page. I was thinking of a windows service or
something similar. They don't want a console application/scheduled
task solution. The budget is TINY.
ACCEPTABLE SOLUTION
A reliable means of saving the XML file periodically. The most
important word in that sentence is "reliable". A background timer in a
macro? A save triggered by a cell's Change event firing?