Maker Pro
Maker Pro

Spreadsheet as realtime viewer?

J

Joerg

Jan 1, 1970
0
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?
 
H

Homer J Simpson

Jan 1, 1970
0
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?

MS_Works, no. Excel, maybe. Try to Open the port/device you want to use from
within VBA.
 
J

Joerg

Jan 1, 1970
0
Sigh. I was afraid that they had dumped it. Maybe I was the only guy who
used it back then?
In case this doesn't work, maybe these do (no own experience):

http://www.taltech.com/


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.
 
D

David L. Jones

Jan 1, 1970
0
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?

It is still there and is called VBA (Visual Basic for Applications or
something)
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.

Dave.
 
J

Joerg

Jan 1, 1970
0
David said:
It is still there and is called VBA (Visual Basic for Applications or
something)
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.

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 ;-)
 
R

Rich Grise

Jan 1, 1970
0
It is still there and is called VBA (Visual Basic for Applications or
something)
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.

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?

Thanks,
Rich
[1] given the caveat that it was written (or purloined) by MICRO$~1.
 
D

David L. Jones

Jan 1, 1970
0
On May 31, 11:01 am, Joerg <[email protected]>
It is still there and is called VBA (Visual Basic for Applications or
something)
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.

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?

Thanks,
Rich
[1] given the caveat that it was written (or purloined) by MICRO$~1.

"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.

Dave.
 
J

JeffM

Jan 1, 1970
0
M

Martin Riddle

Jan 1, 1970
0
Joerg said:
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
;-)


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.


Cheers
 
R

Rich Grise

Jan 1, 1970
0
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?

"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.

Thanks! Looks good! :)

Thanks,
Rich
 
J

Joerg

Jan 1, 1970
0
Martin said:
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.

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.
 
J

Joerg

Jan 1, 1970
0
JeffM said:
Joerg,
If you ever do get this working, it would be interesting to know
if it works under the VBA-compliant fork of OpenOffice.org:
http://www.google.com/search?q=cach...not.complete+qq+Visual-Basic-for-Applications

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.
 
H

Homer J Simpson

Jan 1, 1970
0
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
;-)

MS Works never had it and still doesn't. In Excel, just hit Alt-F11 or go
Tools:Macros:Edit
 
H

Homer J Simpson

Jan 1, 1970
0
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.

O'Reilly has two books on VB6 / VBA.


--
..

--
..
..
..
..
..
..
..
..

--
 
R

Robert

Jan 1, 1970
0
David L. Jones said:
On May 31, 11:01 am, Joerg <[email protected]>
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?
It is still there and is called VBA (Visual Basic for Applications or
something)
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.

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?

Thanks,
Rich
[1] given the caveat that it was written (or purloined) by MICRO$~1.

"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.

Dave.

This page offers compiled Help files on VBA for different MS Applications
including Excel.
http://www.microsoft.com/technet/scriptcenter/topics/office/vba.mspx

Robert
 
J

Joerg

Jan 1, 1970
0
Homer said:
MS Works never had it and still doesn't. In Excel, just hit Alt-F11 or go
Tools:Macros:Edit

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.
 
M

Martin Riddle

Jan 1, 1970
0
Joerg said:
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.

--

Maybe this might help http://www.tmworld.com/article/CA187420.html

Cheers
 
J

JeffM

Jan 1, 1970
0
Joerg said:
We want to create charts from data that comes streaming in
[...]
In newer MS-Works and Excel versions I could not find that feature.
David said:
It is still there and is called VBA (Visual Basic for Applications
Martin said:

Aaaaaaaaa! ActiveX on top of Visual Basic. 8-(
Resistance is futile. You will be assimilated.
http://www.google.com/images?q=billborg
 
Top