VBA with Propeller where VBA is used as library
I was doing some research the other day for work and noticed that VBA - especially Excel - is very good at holding small libraries of data were the tidbits are logged into cells and the cells scanned for additional informtion later.
Example - I am scanning with a PING and IR and logging the results. Instead of putting the information into EEProm I send it to Excel who creates it in a worksheet. The worksheet has a series of three columns - first is a time stamp, second is Ping distance, third is IR distance. Later when the program is restarted, since the same starting point is used, a new set of three columns holding the same information is collected. Each time the program runs new information is collected and then averaged to show what happens.
So here's my question - can a library created in Excel be used to update the information collected and then passed into a Propeller or other such chip in real time?
Example - I am scanning with a PING and IR and logging the results. Instead of putting the information into EEProm I send it to Excel who creates it in a worksheet. The worksheet has a series of three columns - first is a time stamp, second is Ping distance, third is IR distance. Later when the program is restarted, since the same starting point is used, a new set of three columns holding the same information is collected. Each time the program runs new information is collected and then averaged to show what happens.
So here's my question - can a library created in Excel be used to update the information collected and then passed into a Propeller or other such chip in real time?
Comments
Examples of this sort of thing include StampPlot Pro and PLX-DAQ (here). Both are written for the Stamps, but can be used with the Propeller or other microcontroller.
The .Net platform has better support for things like serial communications, which is really all you need to communicate -- via the FullDuplexSerial object -- with any application running on your PC. With VBA you'd need to do serial with the older fashioned OCX/ActiveX stuff, and depending on the library you use is likely to be more restrictive than the standard and by very well documented serial classes available in .Net.
To flow data INTO Excel, you can create a "honey, I'm home" program for the Propeller that downloads its data via serial to a file. Format the file in standard CSV format, and open it in Excel. Excel will know what to do with it.
-- Gordon