HYPERLINK between worksheets

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

HYPERLINK between worksheets

Vadim Gorlovetsky
I am looking for a way for linking between cells of different worksheets
within the same excel file.

The format of hyperlink [workbookName]worksheet!cell seems the only
option suitable for this.

The only problem is a workbookname.

If user saves a file on a filesystem, so a workbook name is a file name,
that application generates.

Hyperlink works fine in this case.

But when user chooses to open the document, generated by servlet,

the name is changed with depend on number of versions in the

"temporary files", so a file name changes from "reportXXXX.xls"

to "reportXXXX[1..X].xls" and hyperlink does not work.


Is there any way to detect/set a current workbook name ?