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 Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlinks



 
 
Thread Tools Display Modes
  #1  
Old October 10th, 2009, 07:38 PM posted to microsoft.public.excel.links
Faceter
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
Ads
  #2  
Old October 11th, 2009, 08:53 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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  
Old October 11th, 2009, 02:52 PM posted to microsoft.public.excel.links
Faceter
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  
Old October 11th, 2009, 03:18 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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  
Old October 11th, 2009, 03:38 PM posted to microsoft.public.excel.links
Faceter
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  
Old October 11th, 2009, 04:01 PM posted to microsoft.public.excel.links
Faceter
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  
Old October 11th, 2009, 10:35 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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  
Old October 12th, 2009, 07:01 PM posted to microsoft.public.excel.links
Faceter
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  
Old October 12th, 2009, 07:19 PM posted to microsoft.public.excel.links
Faceter
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  
Old October 13th, 2009, 07:48 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
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

 




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 12:20 PM.


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