This is a Module in an Excel VBA program. I am working in Excel 2010 and Access 2010.
This works fine if I am adding data to the end of the file.
How do you change "rs.AddNew" to update a certain row and column already entered in the database, db1?
Sub Initial()
Dim cn As ADODB.Connection...