#1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlinks

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

  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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


  #4   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlinks

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

  #5   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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




  #6   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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


  #7   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlinks

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

  #8   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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


  #9   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 10
Default Hyperlinks

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


  #10   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Hyperlinks

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

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
Hyperlinks lindan8r Excel Worksheet Functions 0 July 17th 08 08:28 PM
Hyperlinks: Hyperlinks change on copy/paste? Rick S. Excel Worksheet Functions 0 November 13th 07 09:19 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! jacob735 Excel Discussion (Misc queries) 1 June 22nd 07 12:57 AM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM


All times are GMT +1. The time now is 10:24 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"