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