i would like to create a new recordset, but not connecting to any database. I have a list of items which I can only add into the recordset during runtime.
I wrote the below, but was told by the system that "Operation is not allowed when the object is closed" . I tried to open it, but I receive error "The connection cannot be used to perform this operation. It is either closed or invalid in this context"
Dim country() as string
country = Split(gCountryFromDB, "|", , vbTextCompare)
Dim rsCountryM As New ADODB.Recordset
For i = 0 To UBound(country)
rsCountryM.AddNew "sCountryCode", country(i)
Please help! Thanks!