Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 3
Default hyperlinks in excel2002 won't save correctly

Hi All,

I'm having problems keeping hyperlink paths when i save an excel file as html.

The hyperlink works fine in excel: links to a pdf
"file:///\\server\share\folder\file.pdf" but when saved as html it is just
saved as "folder/file.pdf" I'm using the html on a webserver so need the
entire path.

I tried unselecting 'update links on exit' under toolsoptionsgeneralweb
options, but still the same.

Any ideas?

Thanks in advance,

Alastair
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default hyperlinks in excel2002 won't save correctly

I don't know if it will help with this problem, but some problems with
relative links are solved by File Properties Summary Hyperlink
Base : \\SomeJunkServer\JunkFolder

This forces hyperlinks to the same server as the file is saved on to be
saved as absolute.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 3
Default hyperlinks in excel2002 won't save correctly

Hi,

Thanks for your reply, unfortunately it still will not work, the HTML code
for each link still reads:

href="folder/file.pdf"

Cheers though,
Alastair.

"Bill Manville" wrote:

I don't know if it will help with this problem, but some problems with
relative links are solved by File Properties Summary Hyperlink
Base : \\SomeJunkServer\JunkFolder

This forces hyperlinks to the same server as the file is saved on to be
saved as absolute.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


  #4   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default hyperlinks in excel2002 won't save correctly

Alastair wrote:
unfortunately it still will not work, the HTML code
for each link still reads:

href="folder/file.pdf"


If you create a new hyperlink, with the hyperlink base set as I
suggested, does it come out right?
If so all we need is to fix up any existing hyperlinks which should be
possible using some code.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #5   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 3
Default hyperlinks in excel2002 won't save correctly

Cheers Bill,

With your help I've now solved the problem. I was saving the individual
sheet as html rather than the 'entire workbook'. With the hyperlink base in
place the link in html reads correctly:

<a href="file:///\\server\folder\file.pdf"file</a

"Bill Manville" wrote:

Alastair wrote:
unfortunately it still will not work, the HTML code
for each link still reads:

href="folder/file.pdf"


If you create a new hyperlink, with the hyperlink base set as I
suggested, does it come out right?
If so all we need is to fix up any existing hyperlinks which should be
possible using some code.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Breaks - Excel2002 Deborah New Users to Excel 2 July 4th 07 03:36 PM
Relative Hyperlinks are not saved correctly PH at IUMG Excel Worksheet Functions 0 October 4th 05 08:38 PM
Can Excel2002 determine if a calculated date is a business day? jsmahnken Excel Worksheet Functions 2 September 26th 05 10:39 PM
Save as .xml not displayed correctly Anthony Excel Discussion (Misc queries) 1 September 21st 05 12:01 PM
Custom Cell Format Will Not Save Correctly szyzygy Excel Worksheet Functions 3 July 21st 05 11:55 PM


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"