I am trying to get some data from a SQL server database into Excel.
When I try and open the recordset (RS.OPEN .. ) in the code below I get
Run-time error '-2147217900 (80040e14)'
My references are :
Visual basic for Applications
Microsoft Excel 14.0 Object Library
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft ActiveX Data Objects 6.1 Library