Hi Daniel Thanks for your response. I am having a look at this http://www.aggsoft.com/print-asdl-excel-real-time-charting-export.htm. But I do not think it will do what I want. It goes from device to excel.
Just to explain a little more of what I am trying to do. (way out of my range of ability, but I hope I can find software like above only the correct way), In the early 1980s a digital model railway controller was developed by Hornby UK. I would like to be able to use the receivers in the locos etc and operate from pc. Power supply is ok. The controller sends data down the line to the receiver which is a Texas Instruments TMS100 series 4 bit processor. I have oscilloscope drawings of the waveform and breakdown of data. I can setup on Excel all the commends etc and work out how to convert into necessary language to go down serial or USB (USB prefably) to the device. Then a lot of testing and trials etc. The current system is limited to 16 loco addresses which I will increase up to 64 (I hope) There is a new system called DCC but pricing is quite esxpensve for me and I have lots of receivers etc all paid for. Can pick up used receivers quite cheap. So at the moment I would like to get hold of some Excel compatible software or add-in to take care of converting the numeral instructions from cell in Excel and converting into binary or whatever it has to be (have not established that yet, and also to insert new instructions etc into the data stream. Looking at all the oscillosope data over the weekend. Once converted send it down thru the port and to the receiver device. Not in a hurry and hope to learn heaps in the meantime. It is possible I guess that I find it cannot be done. Thanks and regards Charlie On Thu, Sep 1, 2011 at 2:57 AM, Daniel <dcolarde...@free.fr> wrote: > … or a driver ?**** > > ** ** > > Daniel**** > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Cab Boose > *Envoyé :* mardi 30 août 2011 05:56 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)**** > > ** ** > > Hi once again**** > > **** > > This is totally new subject. I have model railroads. I would like to > control from Excel. (there are some other software available but I would > like to use Excel)**** > > **** > > I want to send from Excel to a bus wire digital information showing the > loco number and direction of travel (fwd/rev) etc. Just for basics etc Send > a message by USB to say:**** > > **** > > Controller1 Engine 5 Fwd Direction 1/2 speed**** > > **** > > In practice there would be several sets of data for different locos.**** > > **** > > There is a digital receiver in loco. (I have drawings of waveforms that it > is sent over etc)**** > > **** > > I know there are lots of things to consider, but at this point I would like > to know if anyone has done something similiar. Is DDE the one to us (old > apparantly) or something different.**** > > **** > > I will make up a spreadsheet to show selection of loco etc**** > > **** > > It may end up being too complex for me, but I would like to give it a try > and get a ssample working turning on an LED etc**** > > **** > > Thanks**** > > **** > > Charlie Harris**** > > (into model trains)**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
