Microsoft Excel for PC Logo
danish Posted on Feb 21, 2014

Hyperlink other document in excel button

I have 100 pdf document with different names. and i want it to open these documents through excel. for example. to open a document i type its name "BOOK1" in a cell and click Excel button to open this document.

1 Answer

ddfisch

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 14 Answers
  • Posted on May 01, 2014
ddfisch
Contributor
Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

Joined: Jan 08, 2009
Answers
14
Questions
0
Helped
2395
Points
27

The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

3 Related Answers

A

Anonymous

  • Posted on Jul 03, 2008

SOURCE: Problem : excle chart in word converted in pdf

['[[[

Ad

Anonymous

  • 53 Answers
  • Posted on Aug 14, 2008

SOURCE: How do you convert a Microsoft Excel 2007 document into a Microsoft Excel 2003 document?

When you save the file, choose "Save As" and choose the option Excel 97-2003 document.

Joed911

JDTec

  • 4338 Answers
  • Posted on Oct 10, 2008

SOURCE: excel wont open the file?

Is it MS Office 2003 ?
Can you open Excel by clicking on it's icon?
If so, go to Control Panel>Add/Remove programs> scroll down to Microsoft Office 2003. Click on change. A box will open up and you and choose "repair and fix". Let it run . it should fix it.

If I could be of further assistance, let me know. If this helps or solves the issue, please rate it.
Thanks, Joe


I’m happy to assist further over the phone at https://www.6ya.com/expert/joe_8b8c2cd6ce148309

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How do I name and save a scanned document in HP C4480 (Windows)?

Hello, Robert -

I hope I am correct in assuming you have the user's manual for the HP Photosmart C4480. Just in case you do not, this is the link to the web page where you can download and save the manual (PDF format - Adobe Acrobat Reader software needed, free):
https://support.hp.com/us-en/product/hp-photosmart-c4400-all-in-one-printer-series/3655558/model/3655559/manuals

After downloading the PDF document save it (Save As) to your Documents folder and give it a name you can find again easily - maybe: HP Photosmart C4480 Manual.

How to save a PDF file:
- With your computer, open the PDF document in Adobe Acrobat Reader
- Move cursor to upper left corner of page and left click or tap on FILE
- In drop down File menu, move cursor to SAVE AS and left click or tap on it
- In Save As window which opens, move cursor down to CHOOSE A DIFFERENT FOLDER and left click on tap on that "button"
- In window which opens choose DOCUMENTS in the Documents Library
- In File name box near the bottom of the Documents Library pop-up window, enter the name with which you want to save the PDF document, Example: HP Photosmart C4480 Manual
- Left click or tap on the SAVE button

Note: The steps above will be similar to what you will need to do after scanning any document.

The instructions for scanning start in Chapter 10, Page 64 (Image 304 of the PDF format manual).

Open the scanner through your computer. It is easier to save the document later by operating the scan functions through your computer.

With the scan application open on your computer run the scan process. After scanning the document, you will need to save it. First, you will need to determine the format in which you want to save the scanned document: PDF, JPEG (photo image), GIF, etc.

After choosing the format for the scanned document, in the proper file name box, enter the name for the document you wish to save.
Examples:
Correspondence 2018-Feb-18 Brother
Photo Brothers-Family 2018-Feb-18
Deed of Sale 2018-Feb-18 House

Get the idea? I like to give a date to my scanned document names to help identify them better.

Once you have entered the file name, click or tap on the SAVE button.

Note: I always like to open the saved document from the Documents folder to verify it was saved. Plus, my scanner attaches a number at the end of every file name. After closing out the saved document and closing the scanner winder, I go back and Edit the file name, removing the added number (digits) from the saved file name.

The video you will find with this link:
http://esvideo.es/video/watch/ult2ORqN1eGRiLQ=
is for those who use Windows 8 or 10. Even if you use another Windows operating system (I use Windows 7), you can probably figure out what to do. The video goes through the scanning and saving process step-by-step.

Best wishes.
0helpful
1answer

When I open an email attachment, it opens the document into a new tab on the brower, not as a pdf, word doc or excel doc. What needs to be changed in my settings?

If you click on the image there are three options View Online, Save to OneDrive or Download
To open with program installed on your computer select 'Download' when the other window opens .. select 'Open With' - Other.
From here you can select the appropriate program you wish to open it with.
Hope this is helpful, please click the Helpful Button below to show your appreciation. Good luck.
1helpful
4answers

How to convert 2007 excel sheet into 2003 excel sheet

if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!
0helpful
1answer

I am trying to hyperlink a word and pdf doc onto front page. Once I hyperlink it - it doesnt work on my actual website what am I doing wrong?

In your hyperlink you have to specify the full path to your document.
I your software makes a hyperlink to the document on your hard drive, then obviously it won't work on a website.
Example:
Your website: www.FooBar.com
your document is located in a folder "/documents/"
The hyperlink should look like
<A HREF="http://www.foobar.com/documents/thedocument.pdf">Click to download document</A>
This is the safest way.

Another important thing: in Windows, documents named Document.pdf, document.pdf, DoCuMeNt.Pdf etc. are exactly the same. On the Web however these are completely different files!
Make sure, that the name in the hyperlink is exactly the same, as it looks like uploaded to your website (via FTP for example). Look at the FTP directory after upload and note the exact capitalization of the the file name, and adjust the hyperlink. Or check the name in hyperlink and rename the file using FTP, whichever you prefer.
0helpful
1answer

In MS Excel 2000 and 2003, I was able to add a ''hyperlink window'' to my toolbar which enabled me to copy the link and place it in emails and other documents. Is there a way to show this hyperlink window...

To create your own toolbar:
  1. Click the Toolbars tab on the Customize dialog box.
  2. Click the New button, and then type a name for the toolbar.
  3. Click the Commands tab, and drag buttons and commands to the toolbar.
regards
2helpful
1answer

Link in excel 2007

right click on any cell then select hyperlink option from the list then a dialog box will appear infront of you
in left hand side pane there is option place in this document click on that then in right hand side pane select sheet 2 or sheet 3 whichever you want...
or if you want to open any other file so use existing file...option
1helpful
1answer

Open attached files from e-mails

If all you are wanting to do is read or print the email attachments, and they have been written using Word 2003 or Excel 2003, you can go to Microsoft.com and download Word Viewer 2003 and Excel Viewer 2003. These two viewers will allow you to read or print either Word or Excel documents as long as the original composer used Word 2003 or Excel 2003, or some earlier version such as 2000 or XP. To the best of my knowledge, Microsoft has not released a viewer for any of its 2007 programs yet.

However, if you are wanting to compose new documents, or edit the attached documents, you will need to have a copy of the program in question.

There is also one other possibility. You can go to openoffice.org and download a free copy of Open Office. I am not sure if the Open Office Suite is 100% compatible with the Microsoft Office products, but it should be close enough to get you by.

One other thing, if you are receiving .pdf documents, you can go to Adobe.com and download the latest version of Adobe Reader. This is also a free download and will allow you to open, view and print the .pdf documents but, again, in order to edit them you will need a copy of Adobe Acrobat (not free) or some other compatible program such as Open Office (again there may be some slight compatibility issues to deal with).

Hope that helps - Graye
0helpful
1answer

Microsoft excell

If you go to MY RECENT DOCUMENTS, (it should be in C:\\Documents & Settings) you chould see the Excel document that you are trying to open. Double click on that document and it should open.

Another way to get the document open is to do a search. Go to START, Search, For files and folders. Type in the name of the document you want to open and then you can open it as described above.

Hope this helps Loringh
Not finding what you are looking for?

152 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...