Hello
I have a problem to use the multimeter HP3458 or HP3457 with VBA EXCEL.
my code
Set ioMgr = New VisaComLib.ResourceManager
Set hp3458 = New VisaComLib.FormattedIO488
Set hp3458 .IO = ioMgr.Open("gpib0::25")
hp3458 .WriteString ("ID?")
A = hp3458 .ReadString ' command TIMEOUT
It is OK with another instrument like a generator
Set ag33250a = New VisaComLib.FormattedIO488
Set ag33250a.IO = ioMgr.Open("gpib0::16")
ag33250a.WriteString ("*IDN?")
A = ag33250a.ReadString ' command OK
when i use HTBASIC, no problem
OUTPUT 725;"ID?"
ENTER 725;A$ ' A$="HP3458A"
ENTER 725;A$ ' A$="-2.1...." ' without question, the HP3458 send the value of the display after triggering
I have Windows 7 64 bits and Excel 2010
If anyboby have a solution, i don't understand the problem
Daniel
I have a problem to use the multimeter HP3458 or HP3457 with VBA EXCEL.
my code
Set ioMgr = New VisaComLib.ResourceManager
Set hp3458 = New VisaComLib.FormattedIO488
Set hp3458 .IO = ioMgr.Open("gpib0::25")
hp3458 .WriteString ("ID?")
A = hp3458 .ReadString ' command TIMEOUT
It is OK with another instrument like a generator
Set ag33250a = New VisaComLib.FormattedIO488
Set ag33250a.IO = ioMgr.Open("gpib0::16")
ag33250a.WriteString ("*IDN?")
A = ag33250a.ReadString ' command OK
when i use HTBASIC, no problem
OUTPUT 725;"ID?"
ENTER 725;A$ ' A$="HP3458A"
ENTER 725;A$ ' A$="-2.1...." ' without question, the HP3458 send the value of the display after triggering
I have Windows 7 64 bits and Excel 2010
If anyboby have a solution, i don't understand the problem
Daniel
Unfortunately, this is the BenchVue support forum, so we can't help you here. Please submit your issue via email to gem_support at keysight dot com. That's the support node for voltmeters.
Brian