Syntax for creating an object 1

[48Highlander]

I am evaluating the IBiz Integrator for QuickBooks. THier documentation is very poor and it doesn't help that I don't know enough about VBA coding.

I have the following code:

    Dim cust As Customer
    Dim strConn As String
  strConn = "ApplicationName= """ & "my app" & """ CompanyFile= """ & "QB path and file name" & """"
    cust.QBConnectionMode = cmDontCare
    cust.QBConnectionString = strConn
    cust.CustomerName = "John Doe"
    cust.Add

When I run this code, I get error 91: Object variable not set. How should I be setting up the cust object in my code?

Bill J

 

[rmikesmith]

Bill,

Try adding the following line of code:

    Dim cust As Customer
    Dim strConn As String
  strConn = "ApplicationName= """ & "my app" & """ CompanyFile= """ & "QB path and file name" & """"
    [COLOR=red]Set cust = New Customer[/color]
    cust.QBConnectionMode = cmDontCare
    cust.QBConnectionString = strConn
    cust.CustomerName = "John Doe"
    cust.Add

Regards,
Mike

 

[48Highlander]

Thank Mike. That fixed it. Unforunately not I get an unsupported QBXML error. The answer to that issue will have to come from the delelopers of the IBiz Integrator.

Bill J