Connect with us

Spreadsheet as realtime viewer?

Discussion in 'Electronic Design' started by Joerg, May 31, 2007.

Scroll to continue with content
  1. Joerg

    Joerg Guest

    Hello Folks,

    We want to create charts from data that comes streaming in in batches
    over USB. My old DOS version of MS-Works could do that. I could pipe
    data in via RS232 and its built-in terminal function and set it up so it
    displays it as a graph. Worked very nicely with logic analyzer data and
    stuff like that.

    In newer MS-Works and Excel versions I could not find that feature. Did
    it vanish?
  2. MS_Works, no. Excel, maybe. Try to Open the port/device you want to use from
    within VBA.
  3. Joerg

    Joerg Guest

    Sigh. I was afraid that they had dumped it. Maybe I was the only guy who
    used it back then?

    A bit pricey for RS232-only but heck, if it works why not? I am
    surprised that they charge so much for DOS importers because many SW
    packages in the DOS days were smarter and could already do that import.
    Such as the old MS-Works.

    That one looks really good, thanks.
  4. Robert

    Robert Guest

  5. It is still there and is called VBA (Visual Basic for Applications or
    Essentially the same as regular Visual Basic, but it has lots of nice
    tie-in's with the spreadsheet, so it's easy to read data from an RS232
    port and dump it into whatever cells you want etc.

  6. Joerg

    Joerg Guest

    Thanks, I'll have to talk to the SW guy about it. I am not a programmer
    and the old Works didn't require a programming language. It just worked ;-)
  7. Rich Grise

    Rich Grise Guest

    Is there a VBA tutorial on-line anywhere? I bought a copy of VB4 back in
    1995 or so, so I'm passing familiar with it, and at my new client's I get
    to use Office 2000, which includes VBA.

    It actually sounds rather powerful[1], but where's the instruction manual?

    [1] given the caveat that it was written (or purloined) by MICRO$~1.
  8. "VBA tutorial" in google gets some pages, and there are almost
    certainly books on the subject.
    There is also online help somewhere in the Microsoft package but it's
    not easy to find and extract IIRC.

  9. JeffM

    JeffM Guest

  10. I believe you need the MSCOMM control. Then add a 'magic' registry key to
    turn it on. Cause its not part of office but part of visual studio.
    Murkey license thing, even MS doesnt know what to do.

  11. Rich Grise

    Rich Grise Guest

    Thanks! Looks good! :)

  12. Joerg

    Joerg Guest

    Thanks. Man, this gets complicated. It was so easy back in the DOS days.
    All I had to do was open the terminal program in MS-Works and that was it.

    Maybe we'll finally do it with the DAQFactory software from Azeotech.
    It's expensive but that has all the stuff in there.
  13. Joerg

    Joerg Guest

    Especially since Noel said in there that not everything is supported
    yet. I'll talk to the SW guy about it but that will probably be some
    time next week.

    OpenOffice has kind of turned me off a bit because it behaves so
    extremely bloated on the PC. Even on one that has 1GB of RAM.
  14. MS Works never had it and still doesn't. In Excel, just hit Alt-F11 or go
  15. O'Reilly has two books on VB6 / VBA.



  16. Robert

    Robert Guest

    This page offers compiled Help files on VBA for different MS Applications
    including Excel.

  17. Joerg

    Joerg Guest

    The DOS version sure did, via it's built-in terminal module. I have used
    that a lot to display logic analyzer data. Remember the old Dolch
    LAM3250? It was about the only tool in my lab that had a RS232 instead
    of those dreaded GPIB ports. Very practical.

    But that was obviously taken out of Windows releases. And even if we
    could make it work again via some fancy USB-RS232 detour I doubt my
    client would be able to buy DOS-Works licenses.

    I'll have to talk to the SW guy about the macro edit method. I am not
    familiar with that macro stuff. Just tried and my Excel does have it, so
    maybe there is hope.
  18. Maybe this might help

  19. JeffM

    JeffM Guest

    Aaaaaaaaa! ActiveX on top of Visual Basic. 8-(
    Resistance is futile. You will be assimilated.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Electronics Point Logo
Continue to site
Quote of the day