On Aug 30, 4:55 am, Cab Boose <swch...@gmail.com> wrote: > 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)
This is beyond me, but the following might be a good starting point: http://msdn.microsoft.com/en-us/windows/hardware/gg487341 You will need to declare the relevant API functions in VBA before you can use them. See the following for more info: http://msdn.microsoft.com/en-us/library/bb687915.aspx This is a complex project, but should be possible in theory. Regards Steve PS I am also a model railway enthusiast, so I'd be interested in how you get on. -- ---------------------------------------------------------------------------------- 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