Hyperlinks

[Melanie]

Hi

I have an xlsm file that I have created and it has hyperlinks to
another excel file. These hyperlinks include the tab name and
destination cell. eg: FileName-Current.xlsx#'Graph'!A1

These hyperlinks work fine the Excel file but when I publish to mht or
html, they do not work.

What am I doing wrong?

Regards,

Melanie

 

[Joel]

The last time I fixed this problem it turned out to be simple. I had to add
the reference "Thisworkbook" in VBA code. You may also need to use
Activeworkbook.

You may have a similar problem with the hyperlinks. you need to use the
complete path name in the hyperlinks. The workbook assumes the default
folder is the same folder where the workbook is located, when you publish the
workbook it doesn't make the same assumptions.

 

[Melanie]

When I mouse over the links on the mht page it appears as though the links
use the entire path to the file. The files are all stored in the same
directory as the mht file as well.

Thanks for you reply!

 

[Joel]

1) Did you fix the problem?
2) Does the pathname include the drive and backslash at the root folder

c:\

3) Are the link name referencing a XLS file or an MHT file. Does the MHT
file exist?

 

[Melanie]

The file that the links are in is an mht file and they point to an xls file
with references to specific worksheets & cells.

When I mouse over the link in the mht file the path is complete with the
computer name, share name and file path.

 

[Joel]

I would then think al the computer and foilder need to be shared to get to
the file. then there may be a firewall that prevents you from getting back
to your own PC! UGH!.

Not sure what the solution is. Can a MHT file get linked back to an XLS?
Again not sure. You may want to try a few experiments to isolate the
problem. Edit one link and see if you can get it to work. Make both the
source and destination files MHT and change the link. Try different folders.

 

[Melanie]

The files are all located on your server so they should be accessible.

I think the problem is the links link to specific sheets and cells. I need
them to link that way as all the sheets are in 1 workbook.

I guess an mht file won't work.

Thanks for your help!!!