AnsweredAssumed Answered

HP3458 with VBA excel

Question asked by leo_mal on Aug 27, 2015
Latest reply on Aug 27, 2015 by w0dz
  • Comment • 1
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  
No one else has this question

Outcomes