Hey everyone, I just found this board. I wrote some VBA to query my SQL Server into a recordset, but I don't know how to display that recordset on my Excel spreadsheet. The recordset is full, so how do I put that into Excel?
I have written an app in VB6 that creates an Excel spreadsheet from an ADODB recordset. I need to use VB during the creation to add a number ot totals columns. I have the variable osheet declared as an object and can execute the command: osheet.range("E8").value = "=a8+b8+c8+d8".