View Single Post
  #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
================================================