vba Connections("ConnectionName").ODBCConnection on Mac

[Jim Gordon]

Hi - Does anyone have a workaround for executing a VBA generated SQL command via ODBC on a Mac?

This works in Windows, but fails on a Mac. stSQL1 is a string variable having the text of the SQL query. The code fails on the With statement:

With ActiveWorkbook.Connections("ConnectionName").ODBCConnection
        .CommandText = stSQL1
 End With