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.
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).
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.
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
152 views
Usually answered in minutes!
×