Cell ID property
Too bad. Being able to save the rowstamp between sessions is critical. Is
there another way, besides using named ranges, hiden columns or comments to
store the rowstamp value?
Regards
Pete
"Peter T" <peter_t@discussions skrev i meddelandet
...
That should be fine as long as you only need those rowstamps in the
current workbook session. IOW the cell's ID property does not get saved.
Regards,
Peter T
"PO" <h wrote in message ...
Excel 2003, sp2
Hi,
I'm using an add-in to retrieve data from a webservice. The data is
"looped" into a table in a worksheet. Typicaly the webservice returns 200
records.
I would like to store each records ROWSTAMP in column A so that the
add-in can retrieve additional information about that record if the user
needs it (and display the additional information in a msgbox). I do not
however want the rowstamp id to be displayed to the user.
Since the workbook already heavyly relies on ranged names I do not want
to use 200 additional range names to store this type of information. I'd
also rather not use a hiden column or cell comment, the cell.id property
seems like a much "cleaner" way to store this information as it is
invisible to the user.
The workbook will never be saved as a webpage. Are there any drawbacks
using the ID property in this way?
Regards
Pete
|