addnew
 

I have a program that has rs.addnew as one of the first lines of code, even
if there are no records to be added. When exiting Excel, an error comes up
that states "memory counld not be written." I believe it is because I cannot
perform an rs.Close command because rs.Update is not executed. Is there a
way to "cancel" the rs.addnew? Or is this a source of a different problem?
Thank you.

Brent

addnew
 

To what does the rs refer? It is obviously a variable of some type, so it
must be declared somewhere as a worksheet, shape, range or what? You could
comment it out of the execution with an apostrophe and see if the code runs
ok.

'rs.addnew

"Brent" wrote:

I have a program that has rs.addnew as one of the first lines of code, even
if there are no records to be added. When exiting Excel, an error comes up
that states "memory counld not be written." I believe it is because I cannot
perform an rs.Close command because rs.Update is not executed. Is there a
way to "cancel" the rs.addnew? Or is this a source of a different problem?
Thank you.

Brent

addnew
 

the rs is an object for a recordset. I am loading data from excel to oracle,
so I think I have to keep it.

Brent


"JLGWhiz" wrote:

To what does the rs refer? It is obviously a variable of some type, so it
must be declared somewhere as a worksheet, shape, range or what? You could
comment it out of the execution with an apostrophe and see if the code runs
ok.

'rs.addnew

"Brent" wrote:

I have a program that has rs.addnew as one of the first lines of code, even
if there are no records to be added. When exiting Excel, an error comes up
that states "memory counld not be written." I believe it is because I cannot
perform an rs.Close command because rs.Update is not executed. Is there a
way to "cancel" the rs.addnew? Or is this a source of a different problem?
Thank you.

Brent