Forums
This topic is locked
Excel spreadsheet record insertion problem.
Posted 01 Oct 2001 11:17:03
1
has voted
01 Oct 2001 11:17:03 Kevin Abbott posted:
Hi,I use an Excel spreadsheet to save data from my web site.
To use my spreadsheet I need to define an area within the worksheet (e.g (within Excel) highlight area to be save/read from, goto Insert -> Name -> Define. (I have three worksheets contained withn the spreadsheet)
The problem I'm having is when an entry is inserted into the worksheet it goes out of scope of the named section. So if say I had =Sheet1!$A$1:$G$6 (named) the next time I use insert record the value would be entered at row 7.
This causes problems because when I want to display these values using dynamic text within Ultradev, Ultradev can't find them because it's only searching the spreadsheet within =Sheet1!$A$1:$G$6.
The error is:
ADODB.Fields (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
Any help would be great.
Thanks.