General information
Category:
Coding, syntax & commands
Title:
Better way to code Excel automation?
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only