Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Hyperlinks

0 views
Skip to first unread message

Faceter

unread,
Oct 10, 2009, 2:38:01 PM10/10/09
to
I have a spreadsheet with hyperlinks to a folder containing different types
of docs. - .xls .doc .ppt .pdf.
The hyperlink goes to the folder but does not open(run) the file. One can
see the file present in the folder.
What should I do to force the link to "run" the file?
This is the line of text for the hyperlink -

=HYPERLINK("611",",611 NVQ Level 4 Strategy.doc")
--
D Rodman

Bill Manville

unread,
Oct 11, 2009, 3:53:16 AM10/11/09
to
Faceter wrote:
> =HYPERLINK("611",",611 NVQ Level 4 Strategy.doc")
>
I think you have the arguments in the wrong order.
It will be trying to open a document named "611"

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

Faceter

unread,
Oct 11, 2009, 9:52:02 AM10/11/09
to
Sorry that link should read
=HYPERLINK("611",",611.1 NVQ Level 4 Strategy.doc")
The first part is the main folder (611)
The second part is the name of the file as it is saved. It is the document
reference 3spc then the title.
--
D Rodman

Bill Manville

unread,
Oct 11, 2009, 10:18:41 AM10/11/09
to
You still have the arguments wrong.
The FIRST argument of Hyperlink is the filename you want to link to.
The second argument is what appears in the cell.

=HYPERLINK("C:\Temp\MyFile.doc", "My File") will show My File in the
cell, in hyperlink format, and will link to the file specified when you
click the cell.

Faceter

unread,
Oct 11, 2009, 10:38:01 AM10/11/09
to
Right
going to try out what you said - be back soon
--
D Rodman

Faceter

unread,
Oct 11, 2009, 11:01:01 AM10/11/09
to
tried it but still no joy. Placed the filename in the first argument and
the text for the cell in the second argument. The response - cannot open
the specified file.

Perhaps I should explain the structure that I am working with?

Main Folder - Test
contains 4 folders - 611, 613, 614, Admin Docs
All of the above will be operated from either a CDRom +RW or DVD +RW
The Hyperlink is required to 'open' a file be it .doc, .xls, .pdf or .html
These documents will be closed in the normal fashion.
The hyperlinks are in cells which relate to the documents viewed like a list
but sorted into groups matching the folder 611, 613 etc.
Does this help at all?
--
D Rodman

Bill Manville

unread,
Oct 11, 2009, 5:35:10 PM10/11/09
to
Sure.
Put the full filename in the first argument and it will work.

Faceter

unread,
Oct 12, 2009, 2:01:03 PM10/12/09
to
Hi Bill
Tried it - still no go. Here's the line of text
=HYPERLINK("611.1 NVQ Level 4 Strategy","Strategy")
611.1 NVQ Level 4 Strategy = filename in full
Strategy = friendly name for the hyperlink cell.

The is all happening via the CDRom
--
D Rodman

Faceter

unread,
Oct 12, 2009, 2:19:01 PM10/12/09
to
Hi
Thanks - about to try it
--
D Rodman

Bill Manville

unread,
Oct 13, 2009, 2:48:10 AM10/13/09
to
Faceter wrote:
> =HYPERLINK("611.1 NVQ Level 4 Strategy","Strategy")
> 611.1 NVQ Level 4 Strategy = filename in full
>

That first argument is not the filename in full - it lacks an extension
and does not have a path (which might be OK in some circumstances).

At least I would expect to see something like
=HYPERLINK("611.1 NVQ Level 4 Strategy.doc","Strategy")

and if that doesn't work then something like
=HYPERLINK("\\MyServer\MyFolder\611.1 NVQ Level 4
Strategy.doc","Strategy")

0 new messages