A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

creating hyperlinks to excel bookmarks



 
 
Thread Tools Display Modes
  #1  
Old June 22nd, 2004, 06:05 PM
Mike
external usenet poster
 
Posts: n/a
Default creating hyperlinks to excel bookmarks

I am using Powerpoint 2000 and I want to publish slides to
my company's intranet site. Within my slides I need to
create a number of hyperlinks to various bookmarks within
the spreadsheets.

In the oridnary course of events I would create the
hyperlink: ..\filename.xls#bookmark

Now, when I try using bookmark in the hyperlink wizard
this comes up with an error. So I simply edit my hyperlink
as above. But When I publish the page the "#bookmark"
portion is simply ignored in the output HTML/XML file.

However, within the powerpoint file itself I can still
open the link in another window quite successfully.

Equally, I can edit the offending tag and insert the
#bookmark, save and open the file and it will work.

So, it seems that there is either something I am doing
wrong or there is a bug within the publish function.

Next I saved the spreadsheet as a web page. Not impressed
by the results by the way. All the nicely named bookmarks
had disappeared to be replaced by cell range names. But at
least I could could use the bookmark function in the
hyperlink wizard this time. However, once again when I
published my slide as a web page these anchor points are
still ignored.

As there are up to 20 such links on any given slide and I
have approx 100 slides to produce, I am keen to find a way
around this without having to resort to manual edit of the
html files.

Is this a bug, a feature or is it just my idiocy?
  #2  
Old June 22nd, 2004, 08:27 PM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default creating hyperlinks to excel bookmarks

It's not you. PPT has a few problems with more specialized types of URLs.

You might want to have a look at our commercial addin for producing HTML from
PPT in a more controllable fashion. It's called PPT2HTML, there's a lot more
info and a free fully functioning demo at http://ppt2html.pptools.com

The current version of the demo won't do what you need it to, since I've only
just now added the capability (and thanks for the nudge in that direction).

If the addin seems like it'll meet your needs, email me on steve at-sign
pptools dot com and I'll send you an updated version to test.

Currently it sees a link to e.g. pathfilename.xls#target in the PPT file and
converts it to a pathless link to filename.xls#target on the assumption that
the linked file will be in the same directory as the html when uploaded to the
web server. Links back to your hard drive obviously won't do. ;-)

Actually, it should do about the same with any file.ext#target except those
that specify a PPT/PPS as the file.

In article , Mike wrote:
I am using Powerpoint 2000 and I want to publish slides to
my company's intranet site. Within my slides I need to
create a number of hyperlinks to various bookmarks within
the spreadsheets.

In the oridnary course of events I would create the
hyperlink: ..\filename.xls#bookmark

Now, when I try using bookmark in the hyperlink wizard
this comes up with an error. So I simply edit my hyperlink
as above. But When I publish the page the "#bookmark"
portion is simply ignored in the output HTML/XML file.

However, within the powerpoint file itself I can still
open the link in another window quite successfully.

Equally, I can edit the offending tag and insert the
#bookmark, save and open the file and it will work.

So, it seems that there is either something I am doing
wrong or there is a bug within the publish function.

Next I saved the spreadsheet as a web page. Not impressed
by the results by the way. All the nicely named bookmarks
had disappeared to be replaced by cell range names. But at
least I could could use the bookmark function in the
hyperlink wizard this time. However, once again when I
published my slide as a web page these anchor points are
still ignored.

As there are up to 20 such links on any given slide and I
have approx 100 slides to produce, I am keen to find a way
around this without having to resort to manual edit of the
html files.

Is this a bug, a feature or is it just my idiocy?


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:29 PM.


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