Create DLL for communication over serial and TCP/IP that will enable Excel with VBA to be used for SCPI programming. Check for an example in the following document:
\BTSync\Manuals\Remote control\Other vendors programming guides\Agilent E364xA (E3646-90001).pdf