Hello,
I'm currently trying to control my N5765A through Excel 2010 with VBA. I'm pretty new to VBA but I am able to utilize DMMs fairly easily. My issue lies in that I know none of the appropriate syntax in order to tell the source what voltage/current values to use. I spent a while scouring the internet to try and get a list of VBA syntax but that came up fruitless. Any help would be greatly appreciated!
Thanks,
Mike
I'm currently trying to control my N5765A through Excel 2010 with VBA. I'm pretty new to VBA but I am able to utilize DMMs fairly easily. My issue lies in that I know none of the appropriate syntax in order to tell the source what voltage/current values to use. I spent a while scouring the internet to try and get a list of VBA syntax but that came up fruitless. Any help would be greatly appreciated!
Thanks,
Mike
We do have some example programs for the N5700 supplies on the web, including Excel. You can find the examples at:
[http://www.home.agilent.com/agilent/editorial.jspx?cc=US&lc=eng&ckey=514495&nid=-35688.384869&id=514495].
These programs use the Agilent VISA IO library.
I have also attached a N6700 MPS example that I wrote that uses Agilent VISA-COM which I think reads a bit better and is a little easier to use than VISA. The commands are different between the two but you can see how to program in the N6700 example.