01-03-2024
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
01-03-2024
07:30 AM
Working with the index of the referenced documents will be the wrong approach. There is no way to sync up the excel row index and the reference document index.
What will work is to get the name of the referenced document then search the excel document for the existing name, record its excel row number then index over one column and save as with the new name.
There is a handy function for this within go excel. Help page shown here.
i = GoExcel.FindRow("mytable.xls", "Sheet1", "Dia", "=", 0.2)Once you find the row you can get the column value of the existing row by using this function or by manually indexing using cell value.
Dim newName as string = GoExcel.CurrentRowValue("column name")
If this solved a problem, please click (accept) as solution.
Or if this helped you, please, click (like)
Regards
Alan
Or if this helped you, please, click (like)
Regards
Alan