Search results

Hello All, I am wanting to know if is at all possible to create a recordset via SQL statement and then select the data from 1 of the columns in that recordset which in turn will be paste on an excel sheet. Code I Have so far below: Sub getscorecard(thing2 As String, thing3 As String...

Hello All, I have a problem. I have an excel document that link to a SQL Server and I need to figure out how to do the following; I have a bit of code that simple Select data from a table and copy the recordset in an excel sheets. Simple. Next part is the bit causing me some problems. The data...

Hello, I am currently developing some scorecards for work which monitor and collate people performance score. So far these scorecard have been developed in Excel using VB code to assit in the condictional formatting. I am now thinking it is time to more these spreadsheet into access under one...