Hi all,

Is there a more maintainable way to code VFP automation of Excel other than "dead reckoning" of cells e.g.

oExcel.ActiveWookBook.ActiveSheet.Range("B5").Value = 100

My client has given me a very complex template to push data across to - I can see coding in hundreds of lines and then them adding a new row half way down the sheet and I have to then go in and increment every cell reference by 1 row.

In Word, I used bookmarks to "tag" a spot in the document and so as long as the bookmark exists, I can find it and insert text. Users can therefore continue to add or change text as long as they leave the bookmarks in.

Does Excel have the ability to "tag" a cell with a name (within the template) so that I can find the cell by name and update it's data?

Albert