I've written similar code for different tables and no problem Any thoughts would be greatly appreciated Code Sub GetDataTest () 'Declare variables' Set objMyConn = New ADODBConnection Set objMyRecordset = New ADODBRecordset Dim strSQL As String MyLoan = 'Open Connection' objMyConnConnectionString = "Provider=SQLOLEDB1;Integrated– means that Excel did not recognize the text is written in the formula (it is unknown to the function SUMM name, it is written with an error) How to Fix Excel Formula Errors?
Excel Names And Named Ranges How To Define And Use In Formulas Ablebits Com
