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

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

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" wrote:

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

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.

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

Right
going to try out what you said - be back soon
--
D Rodman


"Bill Manville" wrote:

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.

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

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" wrote:

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.

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

Sure.
Put the full filename in the first argument and it will work.

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

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


"Bill Manville" wrote:

Sure.
Put the full filename in the first argument and it will work.

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

Hi
Thanks - about to try it
--
D Rodman


"Bill Manville" wrote:

Sure.
Put the full filename in the first argument and it will work.

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

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")

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