Greetings All,

I am looking into if it is possible to control a piece of test
equipement using Excel's macros. More specifically, it is to control a
spectrum analyzer via a GPIB interface card (IEEE 488). The macros
would set-up the analyzer, take the data, store it in an Excel
spreadsheet. From there, I can write the necessary procedures to make
charts and perform some analysis of the data collected.

If someone has some experience already regarding the above or can
point me in the right direction, it would be most appreciated.

Thanks.

RichardG

This looks like a good start:

http://www.reed-electronics.com/tmwo.../CA187420.html

--
Regards,
Tom Ogilvy


"RichardG" wrote in message
om...
Greetings All,

I am looking into if it is possible to control a piece of test
equipement using Excel's macros. More specifically, it is to control a
spectrum analyzer via a GPIB interface card (IEEE 488). The macros
would set-up the analyzer, take the data, store it in an Excel
spreadsheet. From there, I can write the necessary procedures to make
charts and perform some analysis of the data collected.

If someone has some experience already regarding the above or can
point me in the right direction, it would be most appreciated.

Thanks.

RichardG

Tom,

Thanks for your reply, there are lots of interesting articles at that
webpage.



"Tom Ogilvy" wrote in message
...
This looks like a good start:

http://www.reed-electronics.com/tmwo.../CA187420.html

--
Regards,
Tom Ogilvy


"RichardG" wrote in message
om...
Greetings All,

I am looking into if it is possible to control a piece of test
equipement using Excel's macros. More specifically, it is to control a
spectrum analyzer via a GPIB interface card (IEEE 488). The macros
would set-up the analyzer, take the data, store it in an Excel
spreadsheet. From there, I can write the necessary procedures to make
charts and perform some analysis of the data collected.

If someone has some experience already regarding the above or can
point me in the right direction, it would be most appreciated.

Thanks.

RichardG

Tom,

Thanks for the link. That is what I have been looking for.

RichardG




"C.C. \"Chip\" McCoy" wrote in message news:<ozLqd.166114$HA.23362@attbi_s01...
Tom,

Thanks for your reply, there are lots of interesting articles at that
webpage.



"Tom Ogilvy" wrote in message
...
This looks like a good start:

http://www.reed-electronics.com/tmwo.../CA187420.html

--
Regards,
Tom Ogilvy


"RichardG" wrote in message
om...
Greetings All,

I am looking into if it is possible to control a piece of test
equipement using Excel's macros. More specifically, it is to control a
spectrum analyzer via a GPIB interface card (IEEE 488). The macros
would set-up the analyzer, take the data, store it in an Excel
spreadsheet. From there, I can write the necessary procedures to make
charts and perform some analysis of the data collected.

If someone has some experience already regarding the above or can
point me in the right direction, it would be most appreciated.

Thanks.

RichardG