Cannot Expand Named Range - Help

[Snig]

Hi

I've an excel sheet which contains a number of Named Range. I need to
add a number of records in each range. I'm using VB.NET and ODBC to add
rows.

It adds records properly when the number of records are inside the
Named Range. But when the number exceeds - it generates error "Cannot
Expand Named Range". I don't know how many number of rows to be added
in each range - so I cannot preset the size of the range.

What is the work-around?

Thanks...
Snig.

 

[Dave Peterson]

Maybe you could use a dynamic range name.

Debra Dalgleish has some notes at:
http://www.contextures.com/xlNames01.html#Dynamic

 

[DM Unseen]

Dave, Snig

This probably a bug.

ODBC/ADO.NET should never be used with XL dynamic named ranges, since
ADO/.NET cannot resolve them!

Snig, maybe you need to upgrade to MDAC 2.5?

See http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819 for
info on ADO and Excel and named ranges.

DM Unseen

 

[Dave Peterson]

Thanks for the correction. (I've never used ODBC/ADO.Net.)

 

[Snig]

Thanks guys.
I've upgraded to MDAC 2.5

Still I'm getting the same Error.

Am I missing something?

Snig.

 

[Don Guillett]

Don't know since you did NOT stay in the ORIGINAL thread.