What does this mean..?
What does this mean..?
(OP)
I am in excel learning to use VBA so that I can simply try to get a marker value from an Agilent network analyser. I have one of their .xls examples and it does all kinds of things to the analyser, but I can't seem to figure out how to modify the darn thing!
THe analyser is on the network, and my computer is also on the network. The excel example file uses VBA that uses SICL-LAN (Agilent), that uses GPIB calls.
I am sure this is not too hard for somebody... it's just that my head is too hard... haha.
VBA issue:
What does the (1,1600) stuff do?
Dim Data_y(1, 1600) As Double
Dim Data_x(1600) As Double
SICL-LAN issue:
What is the diff between an iread and an ivscanf?
When would you use a scan instead of a read?
SICL-LAN issue:
What does the ", 6, 1, 0&)" part do?
Call iwrite(id, ":CALC1:MARKER1:Y?" + Chr$(10), 6, 1, 0&)
THe analyser is on the network, and my computer is also on the network. The excel example file uses VBA that uses SICL-LAN (Agilent), that uses GPIB calls.
I am sure this is not too hard for somebody... it's just that my head is too hard... haha.
VBA issue:
What does the (1,1600) stuff do?
Dim Data_y(1, 1600) As Double
Dim Data_x(1600) As Double
SICL-LAN issue:
What is the diff between an iread and an ivscanf?
When would you use a scan instead of a read?
SICL-LAN issue:
What does the ", 6, 1, 0&)" part do?
Call iwrite(id, ":CALC1:MARKER1:Y?" + Chr$(10), 6, 1, 0&)





RE: What does this mean..?
VBA issue:
Dim Data_y(1,1600) As Double defines Data_y as a two dimensional array of double precision numbers.
Dim Data_x(1600) As Double defines Data_x as a one dimensional array of double precision numbers.
I'm afraid I guessing about the iread, and ivscanf functions other than they are functions SICL-LAN has defined.
HTH
Todd
RE: What does this mean..?
or goto http://www.home.agilent.com/ and search the technical support there-if you haven't done so already. Otherwise, maybe a more specifice forum on tek-tips.com might help...
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: What does this mean..?
I am starting to figure this out a bit. The SICL part is the worst. Seems complex. But i am getting data from the network analyser now. So that is not so much an emergency now.
I am into the Basic programming stage at this point and now realize that i am not such a good programmer. My instinct is to just throw down a thousand lines of code in a row, with lots of messy variables and stuff... I am quickly building a birdsnest of a program. I need to learn how to do this right. Learning about making general purpose modules that I can call repeatedly...ohwell..
I have another VBA question though..
When creating modules or subroutines in VBA, sometimes they are added to the main program and sometimes they are in their own module window. What is the difference and why would you create another module window for some code?
Thanks,
groundhog
RE: What does this mean..?
Regards,
Mike
RE: What does this mean..?
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk