Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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" wrote: 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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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" wrote: 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" wrote: 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" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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" wrote: 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" wrote: 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" wrote: 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" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
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!!! "Joel" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How can I get rid of the hyperlinks | Excel Discussion (Misc queries) | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |