Roelf
03-11-2003, 06:55 AM
Hi,
I am trying to jump from a html file to an excel file. That part works. Now i try to jump to a specific position in the excel file. I do that, by defining a cellname in excel, then crate a link with href property like: myexcelfile.xls#mycellname, that part works also. The excel file is rather large, and is maintained by someone else. The way he works is: sort the file in a certain manner, add/delete/change a few rows, change the sort to the original sort then republish. If he does that, all celldata is shifted, but the cellnames stay in the same place. What i need to do, is set a reference to the celldata in some way, so when the sort is changed, the link still goes to the correct data. Does anyone know how to do that???
Roelf
I am trying to jump from a html file to an excel file. That part works. Now i try to jump to a specific position in the excel file. I do that, by defining a cellname in excel, then crate a link with href property like: myexcelfile.xls#mycellname, that part works also. The excel file is rather large, and is maintained by someone else. The way he works is: sort the file in a certain manner, add/delete/change a few rows, change the sort to the original sort then republish. If he does that, all celldata is shifted, but the cellnames stay in the same place. What i need to do, is set a reference to the celldata in some way, so when the sort is changed, the link still goes to the correct data. Does anyone know how to do that???
Roelf