Here's some more information:
After a lot of digging through documentation, I've got the U3606B working with a spreadsheet in both Command Expert mode and using VBA with the VISA-COM resource.
This will copy data from the main display to a variable named "Readings" on the spreadsheet
VBA Code:
Option Explicit
Dim ioMgr As VisaComLib.ResourceManager
Dim instrAny As VisaComLib.FormattedIO488
Dim instrQuery As String
Dim instrAddress As String
Public Sub cmdSendFetch()
instrAddress = Range("Instrument").Value ' this is from named var on SS
Set ioMgr = New VisaComLib.ResourceManager
Set instrAny = New VisaComLib.FormattedIO488
Set instrAny.IO = ioMgr.Open(Range("shortName")) ' this is from named var on SS
Dim r, i As Integer
instrAny.WriteString ("OUTPut:STATe 1") ' SCPI command
Application.Wait (Now + 0.00002) ' 1 second pause
r = Range("Readings").Rows.Count
For i = 1 To r
'Application.Wait (Now + TimeValue("0:00:01")) ' 1 second pause
Application.Wait (Now + 0.00001) ' 1 second pause
instrAny.WriteString ("Fetch?")
instrQuery = instrAny.ReadNumber
Range("Readings").Cells(i, 1).Value = instrQuery ' this is from named var on SS
Next
instrAny.WriteString ("OUTPut:STATe 0")
instrAny.IO.Close
End Sub