AnsweredAssumed Answered

8753D S parameters data acquisition on EXCEL

Question asked by adegliangeli on Apr 17, 2008
Latest reply on Apr 21, 2008 by adegliangeli
Hi everybody,

I'm having trouble getting the SXX data from my old 8753D in a Excel Sheet using FORM5 array-data format.

Check out my macro :

#########################################

'When user click on the button

            Dim VNA As AgtServer8714
            Set VNA = New AgtServer8714
            VNA.Connect "GPIB1::16::INSTR"


            ReDim header(0 To 3) As Byte
           
            ReDim data(0 To 1600, 0 To 1) As Variant
           
            VNA.Output "FORM5;S11;"
           
            VNA.Output "OUTPDATA;"
           
            VNA.ReadBytes 4, header    'Read the 4 bytes header
                     
            VNA.Enter data             'Read the 1601 Real and Imaginary data
           
            For i = 0 To 1600       'Display data on the sheet
            Range("A" & i).Value = data(i, 0)
            Range("B" & i).Value = data(i, 1)
            Next i


###########################################

This program don't work.
My question is : How to get the S parameter array data in FORM5?

Thank you,  

Outcomes